Hey Guys,
I'm looking at creating a Macro or using VBA to sort a large table whose row count can vary drastically. The current table I am looking at has 150,000 lines of data. There are 10 stages within the data table and each row has a stage number 1-10 in the first column. The number of rows for each stage can also vary. I would like some way to split this main table into 10 separate worksheets in the same workbook(based on the value of the first column 'stage number')? Is there any simple way to do this?
I'm looking at creating a Macro or using VBA to sort a large table whose row count can vary drastically. The current table I am looking at has 150,000 lines of data. There are 10 stages within the data table and each row has a stage number 1-10 in the first column. The number of rows for each stage can also vary. I would like some way to split this main table into 10 separate worksheets in the same workbook(based on the value of the first column 'stage number')? Is there any simple way to do this?
