Hi all,
I have one sheet with a few 1000 lines in it and I want to split this data up onto roughly 40 sheets depending on the value in column B (a RepID). I am happy with coding to create the new sheet, copy data etc, but I would like to know the best way to code to get the correct selection for each sheet. The data is sorted and has 6 columns that I want to copy. Each ID is also the name of the new sheet which I know before I start so I can have the codes for the sheets saved elsewhere.
Any ideas would be appreciated.
Cheers Bentley
I have one sheet with a few 1000 lines in it and I want to split this data up onto roughly 40 sheets depending on the value in column B (a RepID). I am happy with coding to create the new sheet, copy data etc, but I would like to know the best way to code to get the correct selection for each sheet. The data is sorted and has 6 columns that I want to copy. Each ID is also the name of the new sheet which I know before I start so I can have the codes for the sheets saved elsewhere.
Any ideas would be appreciated.
Cheers Bentley