Jul 22, 2009 at 08:54 AM
Posts261Registration dateSaturday April 11, 2009StatusMemberLast seenJune 21, 2011
Jul 22, 2009 at 11:56 PM
I am creating a macro for an excel workbook that takes all the data from several worksheets and sorts it alphabetically by name(column 4) on a summary page at the end. Now i am trying to add a column on the summary sheet that indicates which worksheet each row of data came from, before it was mvoed and sorted. here is my current code... the title of each worksheet is also listed in E1 if that helps... and i want it to show up in column 7 in the corresponding rows it belongs with... Thanks so much for any help in advance.
MsgBox "Recreation of a summary sheet will permanently delete current summary sheet, to permanently delete press 'ok'"
Application.DisplayAlerts = False
TotalSheets = Worksheets.Count
If Worksheets(Worksheets.Count).Name = "Summary" Then
TotalSheets = TotalSheets - 1
Posts261Registration dateSaturday April 11, 2009StatusMemberLast seenJune 21, 2011307 Jul 22, 2009 at 11:56 PM
The code for adding the sheet name in one column should be put in the macro procedure which takes all the data from several worksheets. Not in any of the procedures listed above as it doesnt have clue which tells from which sheet that data came from