Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    one sheet referencing several sheets (97)

    one sheet referencing several sheets
    I have several excel workbooks emailed to me all the same format essentially.

    I need someway to arrange the data from all of them into one workbook, is this possible?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: one sheet referencing several sheets (97)

    arage

    1) You an open all the workbooks and move all the worksheets into one workbook.

    2) You can have formulas in a workbook that link to another workbook, example:

    In Book1.xls I link to Book2.xls
    Cell A1 on Sheet1 of Book1.xls is linked to Cell A1 on Sheet1 of Book2.xls

    In Book1.xls in cell A1 on Sheet1 I enter the following formula:

    =[Book2]Sheet1!$A$1 You can actually press = in cell A1 and then click on A1 in Book2 and the formula is done for you.

    If you have any other questions let us know.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: one sheet referencing several sheets (97)

    I

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: one sheet referencing several sheets (97)

    arage

    <<< I
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: one sheet referencing several sheets (97)

    because I don

  6. #6
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: one sheet referencing several sheets (97)

    arage

    If you have a single workbook with all of these linking formulas, you don't even have to open the other workbooks.

    Some points to keep in mind:

    1) Have all the e-mailed workbooks detached to a specific folder on some local drive. This will make the formulas all look the same and it becomes easy to debug.

    2) if there is a lot of formulas, Excel may take its time to calculate, there are ways to speed this up depending on what you do.

    3) Try VBA solutions. You could make a copy of the worksheet(s) in one workbook...

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  7. #7
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: one sheet referencing several sheets (97)

    will do, thanks for the help!

Posting Permissions

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