Hey,
I'm looking for some macro help with the data below, as you can see it's just example data at the moment.I'm wanting the data in this sheet to be copied into new documents based on certain critera, but rememering it's original time order and keeping it in date order.
1) If a data set is "London Appt" or "York Appt" then it is copied as values with number formats through to a document called: GMain.xlsx into the sheet GMain
2) If a data set is "Liverpool Appt" or "Manchester Appt" then it is copied as values with number formats through to a document called: IMain.xlsx into the sheet IMain
I will be adding more data to the MainDoc.xlsx bit by bit so instead of re-copying all of the already copied data it should start by matching the date found at the bottom of BW in he Document and Sheet GMain and then add +1 to the date to find out where to start.
Location = Column BM
Date = Column BW
Time = Column A
I've manually done the GMain and IMain sheets to show how it is supposed to come out like.
Bookmarks