Export to separate documents based on specific critera

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.

Hi jaslake,

Well, I'll be adding other apartments to the lists too eventually there will be about 50 different apartments listed.

For example here are some for the GMain.xlsx sheet:
London Appt, York Appt, Birmingham, Leeds, Newquay (H), Canterbury Appt, Hull Appt

For the IMain.xlsx sheet here are some others
Liverpool Appt, Manchester Appt, Portsmouth, Southampton (B.A), Plymouth Appt, Sunderland, Blackpool

I hope that is what you are asking about.
Thank you ever so much for reading

Hey Jaslake,

Thanks once again for your reply.

In regards to your questions yes my files do look similar to as shown but yes there are headers and other bits of text in rows 1 to 14 of which I would like the macro to ignore, at the moment I only have IMain and GMain eventually I will want to add more but it would be "splitting" and copying data based on other variables not the apartment locations, for now IMain and GMain will be more than sufficient.

Thanks

Hi jaslake,

The top 14 rows will vary all the time, is there no way it can just ignore that top section as the data there never needs to be used.

Thanks
- Hy

Hey,

Does anyone have any idea how to do this, I have no idea how to get even close to the macro able to do it.

Thanks
- Hy

Hi jaslake,

Well that's the problem Rows 1-14's data will change all the time, so I can't give details/structure.

Is it not possible to script a macro around only touching data between: A15 and CE LastRow?

My current document is exactly the same structure as shown in my examples only currently it has a A1:B13 full of data

Thanks in advance
- Hy

Hey,

I've given all I can... I have no idea why you're saying bye in that way,

Anyone else know how?

Thanks

Hey,

Still need some help with this :S

Thanks.

Hey,

Still looking for some help on this one,

Thanks in advance.

Bump,

Anyone able to help

Thanks

Up :/

Someone? :D

Thanks

Bump,

Still looking for help

Thanks

No one able to help with this?

Up

Thanks

No one able to help with this?

Up

Thanks

No one able to help with this?

Up

Thanks

No one able to help with this?

Up

Thanks