Nick72310
05-04-2016, 08:09 AM
There is a lot going on here so I will try and explain what I am looking to do the best I can. I have attached my workbook below. This file is just a small example of the "real" file, which I cannot share.
16082
In the file, I have multiple worksheets that contain lists. These lists are complied in column C but have headers every so often that are merged together in columns B:C. There are items that I manually highlight when I use this workbook and I want to copy them all to a separate worksheet. However, there is one other criteria that needs to be addressed. I have a table with a column that contains either the letter "Y" or is blank. If the item is highlighted and contains the letter Y in the table, then I want it copied to the separate worksheet. Otherwise, it should not appear on the separate sheet.
On each sheet, I have named ranges for column B:C if it's needed. My line of thinking was to search the named ranges and if it was highlighted and label "Y" in the table, then it would appear on the separate sheet. I'm not quite sure how to do that though. One thing to note is that the "real" file has a couple thousand lines on each sheet (This # will only increase over time) so I don't want the code to check line by line to see if it gets copied to the other list.
16082
In the file, I have multiple worksheets that contain lists. These lists are complied in column C but have headers every so often that are merged together in columns B:C. There are items that I manually highlight when I use this workbook and I want to copy them all to a separate worksheet. However, there is one other criteria that needs to be addressed. I have a table with a column that contains either the letter "Y" or is blank. If the item is highlighted and contains the letter Y in the table, then I want it copied to the separate worksheet. Otherwise, it should not appear on the separate sheet.
On each sheet, I have named ranges for column B:C if it's needed. My line of thinking was to search the named ranges and if it was highlighted and label "Y" in the table, then it would appear on the separate sheet. I'm not quite sure how to do that though. One thing to note is that the "real" file has a couple thousand lines on each sheet (This # will only increase over time) so I don't want the code to check line by line to see if it gets copied to the other list.