kenyongraham
06-04-2016, 02:32 AM
Hi,
I am trying to split a worksheet that contains a list of data into seperate excel 2016 work sheets.
I have attached the workbook, I am attempting to put all the data categorised in column D:D on sheet 1 on separate sheets named 1, 2,3 4.... corresponding to the case integers ie. 1 to 23
There is an attached macro but I'm stumped on creatimg the loop.
I'm off to read my excel vba for dummies. Frustratingily I use to be able to achieve this.
Too many grey cells have gone to make way for invaluable facebook rubbish.
rgds
Kenyon
1631616316
I am trying to split a worksheet that contains a list of data into seperate excel 2016 work sheets.
I have attached the workbook, I am attempting to put all the data categorised in column D:D on sheet 1 on separate sheets named 1, 2,3 4.... corresponding to the case integers ie. 1 to 23
There is an attached macro but I'm stumped on creatimg the loop.
I'm off to read my excel vba for dummies. Frustratingily I use to be able to achieve this.
Too many grey cells have gone to make way for invaluable facebook rubbish.
rgds
Kenyon
1631616316