Results 1 to 2 of 2

Thread: Import data from another workbooks

  1. #1

    Thumbs up Import data from another workbooks

    Hi, i am really really stuck, and i hope someone can help me..


    I receive daily price spreadsheet for all locations everyday(ex.20110528.xls, 20110529.xls, 20110530.xls), and i would like to import these data to a master price workbook(without open each single one), because my boss don't want to enter them day by day for all locations(so many)...

    I would like to create a macro to look up prices from daily workbooks to the master sheet, and i don't want to mast up the formula and format on the master sheet.

    please help....please!!
    Attached Files Attached Files

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Dec 2005
    Do they reside in a known location?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

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