I need to delete rows on one sheet from a list on another sheet. Since the data-set is huge, I can't do this one line at a time so thought using autofilter would be faster.
Filter Sheet "Data" by the names in column B of sheet "Table"
Delete all rows that are not filtered (do not delete rows where column C contains the names in column B of sheet "Table".)
1. List of names in column B of sheet "Table" can change and the number could change so need to create a dynamic array?
2. Number of rows on sheet "Data" will be many, many thousands so deleting one row at a time will not work.
Example workbook attached.
Thanks in advance,