Splitting Data from One Worksheet to Many Automatically
in [General]
|
From: Richard on 27 Apr 2010 08:12 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
From: Eduardo on 27 Apr 2010 08:25 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
From: Pete_UK on 27 Apr 2010 12:13 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 <Rich...(a)discussions.microsoft.com> 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
From: Richard on 6 May 2010 18:10 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 <Rich...(a)discussions.microsoft.com> 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 > > . >
|
Pages: 1 Prev: Delete the contents of a cell if it contains #DIV/0! Automaticall. Next: MATCH |