I have a large parts database, 5000 rows. I want to be able to copy a range within a row from worksheet A "Combined" when column M in worksheet A equals "X". I would then like to paste this range into worksheet B which would be titled the same as column M from worksheet A. Currently I have 163 different possible values from column M in worksheet A, so I will be coping data from worksheet A to create 163 different inventory lists. I have created all the worksheets for the workbook, I just need help with the code to move the data.
The "Combined" worksheet A is a living document and will be added to as new parts are added to the inventory. I was thinking it would be best to run a MACRO in the "Combined" worksheet that will loop through all 5000 rows, looking at column M to equal "X", coping A:T in that row and pasting the range in the worksheet B "titled the same as the value in column M", filling worksheet B down row by row.
Help, I confuse myself.
Bookmarks