Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Summary Sheet shows content from other worksheets (Excel 2003)

    I have an Excel workbook containing four worksheets and I want to place on one of the sheets name "Summary" the content from the other three sheets such as Sheet 1, followed vertically by Sheet2, then sheet 3. Is there some built in methiod to link the sheets together. The column headers for the three sheets are the same so repeating the headers is not required.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Summary Sheet shows content from other worksheets (Excel 2003)

    No builtin way. A simple way is to just use copy and paste from each sheet

    I would then delete the original sheets, I see no need to keep multiple copies of the same data. Using the combined allows much easier manipulation and the use of built-in routines (filtering, pivot tables, etc)
    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Summary Sheet shows content from other worksheets (Excel 2003)

    I don't think there's a standard built-in method. You can copy ranges, then use Edit | Paste Special... on the summary sheet and click Paste Link to create a link to the original data. If you edit cells in one of the three source sheets, the corresponding cells in the summary sheet will be updated automatically. But the link formulas don't handle insertion or deletion of cells.

Posting Permissions

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