Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Please Help, I need a macro to import data conditionally

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

    Default

    Please Help, I'm a newbie when it comes to excel so if someone could help it would be of great help. I need a macro to import data conditionally from one file to another based on contents of more than one column. I need to set up an excel file that will auto update based on raw data entered and import only the rows that contain a specific number in either of two columns.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 05:32, biodand wrote:
    Please Help, I'm a newbie when it comes to excel so if someone could help it would be of great help. I need a macro to import data conditionally from one file to another based on contents of more than one column. I need to set up an excel file that will auto update based on raw data entered and import only the rows that contain a specific number in either of two columns.
    Have a look at the Help file for Query (MSQuery), let me know if it's the sort of thing you need and how we acn help from there.

    I use it quite a lot to conditionally import from Access/Excel/CSV/Oracle (you get the picture). I think it's exactly what you need.
    "Have a good time......all the time"
    Ian Mac

  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I agree with Ian:
    I use MS query to develop workbooks that query over 2500 Oracle tables in our database. I am usually automating them for use by database challenged individuals. MS Query is a great tool for importing directly into Excel, with many options available for parameters and criteria. Note: Learn to write the queries in design mode so as not to depend on the wizard

    [ This Message was edited by: lenze on 2002-05-08 07:02 ]

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

    Default

    Thanks guys, Problem solved though it was still tricky.

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
  •