Per forum rules my other post is getting deleted and here it is with amended title.
I started a new thread to clean up the mud in my head from the post I have here:
https://www.excelforum.com/excel-pro...ml#post4678882
Goal is simple. My data set has headings in row 1. All data is nicely at the top as in first few rows. All rows are empty below the last row containing any data. In the attached sample worksheet, column A has values, then there are values in K, M & N.
This will all happen in sheet2 (second tab):
1. Fill any blanks between values in columns K & N with the value "No current UPC". The sample worksheet has one blank in each of these columns.
2. Filter column K for cells with yellow fill color and move those cells to column R
3. Clear filters
4. Filter column R for blanks. IF no blanks, THEN exit sub. (this is where i keep bugging out. Tried coloring every blank row purple to filter them out, but did not work. Tried populating "xxx" in every blank row to filter them all out. Seems more plausible but cannot seem to make it work. Post referenced in link)
5. Filter column N for cells with yellow fill color and move those cells to column R
6. Clear filters
7. Filter column R for blanks. IF no blanks, THEN exit sub.
8. Move data from columns K & N to column R using logic formula. Formula = "=IF(RC[-7]<>""No current UPC"",RC[-7],RC[-4])"
9. Clear filters
10. Filter for orange fill color in column M. IF no orange cells are present, THEN exit sub.
11. Populate column V with formula. Formula = "=IF(RC[-11]=""No current UPC"",""No current UPC"",(RC[-8])"
12. Clear filters
13. Remove formula from column V (paste values)
14. Filter for green fill color in column M. IF no green cells are present, THEN exit sub.
15. Populate column T with formula. Formula = "=IF(RC[-9]=""No current UPC"",""No current UPC"",(RC[-6])"
16. Clear filters
17. Remove formula from column T (paste values)
Bookmarks