I have a tab called Master in my workbook. This tab includes a ton of data. It has 8,300+ rows and columns from A-AF. Data is entered into the Master tab once a week, so the rows will continue to grow. One of the columns on the spreadsheet is "Customer ID." Let's say we have 100+ Customer ID's.
I'm wanting to extract every row that does not contain one of 15 different "Customer ID's" to another tab within the same workbook. Let's call this tab "Others." I want the "Others" tab to automatically update each time the "Master" tab is updated.
I'm decent using excel formulas, but I don't think a formula is the best answer here. From the research I've done on this, I need to write a VBA code, but I'm not sure where to start.
If anyone could provide step-by-step instructions on how to write the code for Dummy's, that would be greatly appreciated!
I'm wanting to extract every row that does not contain one of 15 different "Customer ID's" to another tab within the same workbook. Let's call this tab "Others." I want the "Others" tab to automatically update each time the "Master" tab is updated.
I'm decent using excel formulas, but I don't think a formula is the best answer here. From the research I've done on this, I need to write a VBA code, but I'm not sure where to start.
If anyone could provide step-by-step instructions on how to write the code for Dummy's, that would be greatly appreciated!