Results 1 to 10 of 10

Populate Master workbook with selected cells from all remaining open workbooks

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2010
    Location
    Clearwater, Florida
    MS-Off Ver
    Excel 2007
    Posts
    8

    Populate Master workbook with selected cells from all remaining open workbooks

    I have attached Master as an example of what my Master workbook looks like. Book2 is an example of the file I need to pull selected cells from and populate into the Master. I typically don't have more than 5 of these open at once.

    Process:
    I will receive emails with up to 5 Book2 like individual workbooks attached. I open them all up. I open the Master workbook after. Unfortunately the filenames I receive are random generated names so can Master check for <> name Master instead of hard code Book2?

    What I need:
    Master to import highlighted cells from Book2, Book3, etc and paste them in the cooresponding highlighted cells in Master. Book2 would be row 2 in Master, Book3 would be row 3, etc. The blank cells in Master row 2 (not highlighted) will be filled out already. If Book3, Book4, Book5, etc exist I need Master to copy the white cells of Master row 2. (example: If Book3 exist, B2 = B3, D2 = D3, E2 = E3, H2 = H3, etc)

    Please let me know if I need to answer any questions. Thank you very much!
    Attached Files Attached Files
    Last edited by marinemerchant; 10-15-2010 at 11:53 AM.

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