LoneRanger
New Member
- Joined
- Dec 18, 2016
- Messages
- 17
So I'm looking to combine about ten fixed work books where all the sheets are with the same name called "events" and I'm looking for it to basically start on row 7 and if there's a value in Column A copy that row to a new workbook. Once all event lists have been copied from each workbook I would like to sort them out by start date which is column D.
The goal is to gather everyone's events and sort them out chronologically ascending starting from the earliest date to the most future date.
Finally I would like to be able to update the same sheet by re-polling the information.
Any help is appreciated.
The goal is to gather everyone's events and sort them out chronologically ascending starting from the earliest date to the most future date.
Finally I would like to be able to update the same sheet by re-polling the information.
Any help is appreciated.