I would be really grateful if anyone could help me with this problem in Excel please...It's driving me nuts !! Please bear in mind i am a complete novice as far as formulas are concerned so would be grafteful if any answers are given in a simply way for a simple guy!!!
I have multiple worksheets named "day1, Day2, Day3.....Upto Day10"
The columns are named as below
A = Location
B = Event
C = Name
D = Start
E = Finish
F = ID
The number of rows on each sheet can vary each day.
What i would like to do is to insert a sheet called "Summary" at the end of the workbook and have a "formula" which will firstly...
Copy all the rows from each sheet to the "summary" sheet, once copied....
Sort all the rows by Column F "ID"
I hope this is firstly possible !! but also explained quiet well.
Many thanks for any help or advice given
Best regards
Paul
Bookmarks