I have been having difficulty trying to create this macro for a spreadsheet I use all the time that contains customer orders that I want to break down into separate sheets based on the product category. Column A of the raw data, holds the Product Category, with values between 1 and 10. I want to create a macro that will start at the top of my spreadsheet and go row by row, looking for specific values in Column A, and then when it finds that value, highlighting that entire row and copying it to another sheet.
For example, all rows in the main spreadsheet that contain 1 in column A for Product Category, should be highlighted and copied to a new sheet in the same workbook, named "Product Cat 1". And then so on and so forth for every other Product Category, 2-10.
Thanks for any help you can give.
Bookmarks