Hi,
I have a master worksheet call "All Locations". It contains 23000 rows of data for 66 of our locations. The data across is in columns A through S.
Each location starts 339 rows after the next ie. location 1 begins on row 1, Location 2 begins on row 339, location 3 begins on row 679 etc.
I need a macro that will take the data for each location and copy it into its own sheet so I will have 66 sheets with 339 rows of data in each (columns A through S).
The names of the locations are in column F and copied down through the 23000 rows (with the names chaging every 339 rows to be with its respective center). If these could be on the worksheets to identify the sheet that would be great but not mandatory.
Thanks
I have a master worksheet call "All Locations". It contains 23000 rows of data for 66 of our locations. The data across is in columns A through S.
Each location starts 339 rows after the next ie. location 1 begins on row 1, Location 2 begins on row 339, location 3 begins on row 679 etc.
I need a macro that will take the data for each location and copy it into its own sheet so I will have 66 sheets with 339 rows of data in each (columns A through S).
The names of the locations are in column F and copied down through the 23000 rows (with the names chaging every 339 rows to be with its respective center). If these could be on the worksheets to identify the sheet that would be great but not mandatory.
Thanks