Hi, new to the forum but have been enjoying the YouTube channel.
The Ask is.
I have data one sheet1 with 30k+ rows and I have another sheet that has a list of values that the user puts in to keep on sheet1. Another requirement is that it may contain more columns.
For example.
Sheet 1 will generally have about 10 columns ranging from employee name, ID, etc.
Sheet2 won't have all these columns, but should allow flexibility to allow from 1-10 columns. The header for both sheets will be same. So let's say on sheet2 under Employee location column A, we have Canada then US. On sheet1, under the same header, if the cell doesn't match either Canada or US, that row gets deleted.
Then on sheet 2 column B, it's Employee start date and then it has a list of dates. On sheet1, if the dates doesn't match, then that row gets deleted.
Then if we have a column C, on the header row, if there is data, do the same. If column C header row doesn't contain any data, then macro should end.
I hope this makes sense.
Thanks in advanced.