ytjjjtyj
08-19-2019, 02:21 PM
Hello,
In Sheet1, I have rows 3,4, and 5 that contain cells that are highlighted. The highlighted cells after column A and B show that the data is bad and should not be put in final sheet. Each highlighted cell is in a column and other named ranges corresponding to that same column will not go in the final sheet.
I want to make a code that will pick only the columns in the named range set that corresponds to none of the highlighted cells ( I can have all of the named ranges pulled over even the ones in Sheet2 EXCEPT the named range called "POP") to bring to the final sheet called "Final_504", taking their data in column A and B along with them.
I made the outcome manually in the final sheet to let you see what I am saying but I need to code it in a generic way. So if I was to do this with 500 data points, I could.
Can anyone help me with this? :(
In Sheet1, I have rows 3,4, and 5 that contain cells that are highlighted. The highlighted cells after column A and B show that the data is bad and should not be put in final sheet. Each highlighted cell is in a column and other named ranges corresponding to that same column will not go in the final sheet.
I want to make a code that will pick only the columns in the named range set that corresponds to none of the highlighted cells ( I can have all of the named ranges pulled over even the ones in Sheet2 EXCEPT the named range called "POP") to bring to the final sheet called "Final_504", taking their data in column A and B along with them.
I made the outcome manually in the final sheet to let you see what I am saying but I need to code it in a generic way. So if I was to do this with 500 data points, I could.
Can anyone help me with this? :(