Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Data from One Worksheet to Many Automatically
Is it possible to split data from one worksheet to seperate worksheets based
on a criteria in Column A, e.g. day / month / surname / etc. I have a master list of data which changes frequently and it is split into seperate worksheets for individuals to review data specific to them. I want to automate copying the data from the master schedule to the seperate individual worksheets. Thanks. -- Richard |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Data from One Worksheet to Many Automatically
Hi,
The macro as follow will create a tab for each row in column A, in the macro the list is in sheet2 change it for your sheet name, and the range mine is from row 1 to 88 Sub Add_NameWS() 'Add and name sheets using ' list in A1:A88 in Sheet2 For i = 1 To 88 Worksheets.Add.Name = _ Worksheets("Sheet2").Cells(i, 1).Value Next End Sub "Richard" wrote: Is it possible to split data from one worksheet to seperate worksheets based on a criteria in Column A, e.g. day / month / surname / etc. I have a master list of data which changes frequently and it is split into seperate worksheets for individuals to review data specific to them. I want to automate copying the data from the master schedule to the seperate individual worksheets. Thanks. -- Richard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Data from One Worksheet to Many Automatically
Yes, it is possible to do this. You could use formulae, but you would
need to fix the values within each of the subsidiary sheets before sending them off to individuals. If you are doing this frequently it might be better to use a macro. Either way, you would need to supply more details of what data you have and exactly what you want to do with it. Hope this helps. Pete On Apr 27, 1:12*pm, Richard wrote: Is it possible to split data from one worksheet to seperate worksheets based on a criteria in Column A, e.g. day / month / surname / etc. I have a master list of data which changes frequently and it is split into seperate worksheets for individuals to review data specific to them. *I want to automate copying the data from the master schedule to the seperate individual worksheets. Thanks. -- Richard |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Data from One Worksheet to Many Automatically
Thanks Pete.
Without going into too much detail Column A would have categories such as W01, W02, W03 etc, There would be many rows for each category. I just need to know how to write a macro to remove or copy all rows with W01 into a worksheet called W01 (with the macro also creating the worksheet), and then does the same for W02, W03 etc. The worksheet that contains the full list of data would be called Summary. Thanks, richard "Pete_UK" wrote: Yes, it is possible to do this. You could use formulae, but you would need to fix the values within each of the subsidiary sheets before sending them off to individuals. If you are doing this frequently it might be better to use a macro. Either way, you would need to supply more details of what data you have and exactly what you want to do with it. Hope this helps. Pete On Apr 27, 1:12 pm, Richard wrote: Is it possible to split data from one worksheet to seperate worksheets based on a criteria in Column A, e.g. day / month / surname / etc. I have a master list of data which changes frequently and it is split into seperate worksheets for individuals to review data specific to them. I want to automate copying the data from the master schedule to the seperate individual worksheets. Thanks. -- Richard . |
Reply |
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 | |||
SPLITTING DATA INTO NEW WORKSHEETS FROM ONE WORKSHEET | Excel Discussion (Misc queries) | |||
Automatically Filling In Corresponding Data from Another Worksheet | Excel Discussion (Misc queries) | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
automatically copy data from one worksheet to another | Excel Worksheet Functions |