Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Search a database and copy content to another file

  1. #11
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey Pse,

    That would do pretty well I'd say.

    Let's say I have all the destinations in coulmn B in my database. Then I would like to perform a search in the database and column B only. Let's say I'll search for MIA i.e., then for all matches of MIA in column B I want Excel to copy a few selected cells on that row into a new file named "Flights to MIA" or something as you suggest.

    I realise that a macro would be a great soulution for this, but then I also need to search for LAX, ORD, JFK or whatever and create an individual file for each destination also easy to update.

    Do you think you know how to do this?

    Kindest regards,
    Marcus Karlsson

  2. #12
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I recieved your sheets.
    All seems to be self expanatory.
    I wish I knew German though.

    Here is what I propose to do.
    If anyone has any suggestions, please post.

    Simply put, when a qualifying cell is changed on your data base, the individual destination file will be updated or created if it does not exist.

    This will be done in real time without the need for any further action from the user.

    I do have one further question.

    How do you want the destination files to be purged of old records?

    After the flight is completed?
    At specific time intervals?
    Or do you want the data to keep piling up?

    I could not find an actual arrival time on your database, only scheduled arrival times.

    How will the seperate, individual destination files know when to clear obsolete records?

    Tom



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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