| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split 1 Master Worksheet to Many
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 | +-------------------------------------------------------------------+ -- Vlad999 ------------------------------------------------------------------------ Vlad999's Profile: http://www.excelforum.com/member.php...o&userid=33586 View this thread: http://www.excelforum.com/showthread...hreadid=545755 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
| link a cell in the 'Master' worksheet list to a 'Detail' worksheet | Excel Programming | |||
| Master sheet to split sheets back to another master sheet | Excel Programming | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
![Vlad999[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
