I have 10 columns of data with up to 30,000 rows. I need to search for different numbers in column C and paste the row(s) of data found onto different sheets. Example: search for all of the “12345” numbers in column C. Each time it finds the number “12345” cut the complete row of data from Sheet 1 paste it onto Sheet 2. It must continue this loop until all rows of column C have been searched. Then search for number “78910” using the same process, search for number “13579” using the same process, etc.
I do have 3 numbers that will need to go to the same Sheet, call it Sheet 5. Example: search Sheet 1 for “24680” and “54321” and “98765”, cut the complete rows of data from Sheet 1 and paste it onto Sheet 5.
I have a working program but I am very new to VBA and not very good. The program I have created will not delete the data but will paste it to the individual Sheets.
Bookmarks