Hello,
I've built a macro to copy data from multiple worksheets to a single workbook, and want to take it to the next step by sorting the copied data in certain worksheets based on a cell value from the original worksheet.
Essentially I'll be receiving data I need to analyze from multiple sources. I will need to collate all the data into one workbook and then sort each entry to its own worksheet based on its product designation (Cell Value) that will be a string and not a numerical value.
I've poked around on forums without much progress into morphing other peoples idea to fit mine issue. The data I'm copying in nothing big (5x6) but analysis is much easier if I'm doing a single product type on one sheet.
I've built a macro to copy data from multiple worksheets to a single workbook, and want to take it to the next step by sorting the copied data in certain worksheets based on a cell value from the original worksheet.
Essentially I'll be receiving data I need to analyze from multiple sources. I will need to collate all the data into one workbook and then sort each entry to its own worksheet based on its product designation (Cell Value) that will be a string and not a numerical value.
I've poked around on forums without much progress into morphing other peoples idea to fit mine issue. The data I'm copying in nothing big (5x6) but analysis is much easier if I'm doing a single product type on one sheet.
