Copying a master sheet to multiple sheets VBA

rusted314

Board Regular
Joined
Jan 12, 2010
Messages
74
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
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

rusted314

Board Regular
Joined
Jan 12, 2010
Messages
74
I forgot to mention the I am using vlookups in my master document so the data would need to be copied and pasted values.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,273
Messages
5,657,777
Members
418,413
Latest member
Radoslaw Poprawski

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top