V
Vlad999
Ok I have one main data sheet and I am looking for a macro to split that
sheet into many spreadsheets.
Each set of data is seperated by a blank row. Data sets are variable.
I have attached 2 spreadsheets to show what i start with and what I am
trying to have when the macro runs through its process.
The "My Master Data sheet.xls" Sheet is the sheet i start with and "My
Goal.xls" is what I want the spreadsheet to look like at the end of the
process.
+-------------------------------------------------------------------+
|Filename: Help.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4815 |
+-------------------------------------------------------------------+
sheet into many spreadsheets.
Each set of data is seperated by a blank row. Data sets are variable.
I have attached 2 spreadsheets to show what i start with and what I am
trying to have when the macro runs through its process.
The "My Master Data sheet.xls" Sheet is the sheet i start with and "My
Goal.xls" is what I want the spreadsheet to look like at the end of the
process.
+-------------------------------------------------------------------+
|Filename: Help.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4815 |
+-------------------------------------------------------------------+