• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Filter Out Multiple Criteria

    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...
  2. K

    Conditional Formatting using another cell value

    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.
  3. K

    Conditional Formatting using another cell value

    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...
  4. K

    Count # of records based on difference between 2 dates

    Yes, this is perfect. Thank you very much!
  5. K

    Count # of records based on difference between 2 dates

    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...
  6. K

    Insert multiple rows at change in value

    Thank you! It now works beautifully. KathrynJ
  7. K

    Insert multiple rows at change in value

    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...
  8. K

    Insert multiple rows at change in value

    Alan, thanks for the suggestion. I did think about using the Subtotal function, but it complicates with the next steps I need to take with this data.
  9. K

    Insert multiple rows at change in value

    Ahh, got it. I'll play with this a bit and let you know if I have more questions. Thank you!
  10. K

    Insert multiple rows at change in value

    I don't see the macro for this.
  11. K

    Insert multiple rows at change in value

    Attached is a test file. The first worksheet (Data) shows the original data; the second worksheet (Results) shows how I want the results to look.
  12. K

    Insert multiple rows at change in value

    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...
  13. K

    Copying data from Variable Worksheet Names

    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...
  14. K

    Copying data from Variable Worksheet Names

    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...
  15. K

    Attach separate worksheets to designated email addresses

    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...
  16. K

    Cut and Paste Rows using variable row count

    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"...
  17. K

    Cut and Paste Rows using variable row count

    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?
  18. K

    Cut and Paste Rows using variable row count

    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...
  19. K

    Cut and Paste Rows using variable row count

    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...
  20. K

    Attach ascending alpha character to a number

    Thank you!! This works beautifully.
  21. K

    Attach ascending alpha character to a number

    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...
Back
Top