Results 1 to 21 of 21

Export to separate documents based on specific critera

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-07-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    358

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1