I have a column with multiple values (approx 25) and I want to filter it based on the values I don't want to have visible. Is there a way to "filter out" multiple values? I know how to filter for values I want to see using Array, but I don't know how to do the reverse of that.
This I know...
Than you, but what I really need is the formula to use within the conditional formatting function in order to make this happen based on the rules listed on my sample file.
I have 2 columns that are date fields. I want to shade the cells in column B in different colors based on the number of days between the values in each column. Attached is sample file and list of rules. I can't seem to get the conditional formatting to work. Once that's working, I then want...
I need a formula to first calculate the number of days between 2 dates, and then sum the number of records based on # of days criteria.
I've tried using DATEDIF(start-date,end_date,"d") and it will give me the number of days, but I don't know how to then sum the number of records within a...
Narayan,
I copied the macro and added it to my actual workbook. When I try running it, I get an error message that says "invalid use of the me command". Here's the code where it's used - in 3 places.
Application.ScreenUpdating = False
firstrow = 6...
I have a file where column A has values in varying number of rows - for example:
City Name (Header on row 6)
- Chicago (has 14 rows with this value)
- New York (has 6 rows with this value)
- Atlanta (has 25 rows with this value)
etc.
I want to insert 2 blank rows at each change in value.
And...
I've been trying, but still don't quite get this. I forgot to mention that the path to the file also includes an LOV to select the correct folder (which also changes each month). So I'm confused on how to use LOV to select the new folder, and another LOV to select the new worksheet. Both of...
Each month I need to copy a report that uses the same workbook each month, but with a different worksheet each month (i.e., 1-16 to 2-15-17; 2-16 to 3-15-17; etc.). On the workbook where I want to paste the data, I've added a field with an LOV to select the correct worksheet name each month...
My workbook has multiple worksheets, one for each client. I want to send a separate email to each client, and include their respective worksheet as an attachment. One of the worksheets lists all of the client names and email addresses. I need help with a macro to match the client names to...
Here's a way I made it work by adding code to delete the rows from sheet1.
Dim lrow As Long
lrow = Range("D" & Rows.Count).End(xlUp).Row
Sheets("Sheet1").Select
Rows("6:6").Select: Selection.AutoFilter
ActiveSheet.Range("$D$6:$D$" & lrow).AutoFilter Field:=1, Criteria1:="OM*"
Range("D7:S"...
When I change copy to cut, I get an error on the last row: "PasteSpecial method of Range class failed".
Range("A" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial
Any other suggestions?
This works up to a point. I actually want to remove/cut the rows from the first sheet, not simply copy them. But I can't seem to get that to work.
Here's my code:
Dim lrow As Long
lrow = Range("D" & Rows.Count).End(xlUp).Row
Sheets("Sheet1").Select
Rows("6:6").Select...
I want to find all the cells in column A that begin with "OM", and then cut the entire rows and move (paste) them into a second worksheet. But each month the row count will change - so I can't use a simple range of rows (i.e., rows 100-200). They will vary from month to month. Is there a...
I have a file with duplicate order numbers and need to add an alpha character to the end of each one - in ascending alpha order. Can this be done? Example:
1263197
1263917
1263917
1263917
Is there a formula that will attach a different alpha character, in ascending order, to each duplicate...