Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2004
    Location
    Easley, South Carolina, USA
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy Multiple Selections (Excel 2003)

    I need to Copy and Paste the values from two areas of a Spreadsheet into another Summary Spreadsheet. The values need to be summed into the Summary Spreadsheet. Is there a simple way to accomplish this without writing a VBA script? The Summary Spreadsheet has exactly the same data format and cell locations and the source Spreadsheets. Any suggestions would be greatly appreciated.

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

    Re: Copy Multiple Selections (Excel 2003)

    What's the problem with first copying and pasting one area, then copying and pasting the other area? That can't take much time.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy Multiple Selections (Excel 2003)

    <P ID="edit" class=small>(Edited by franciz on 02-Sep-08 02:11. provide Note)</P>if you don't want to go thru the copy and paste keystrokes, put a " = " sign in the locations of your Summary Sheet with
    reference to the Source sheet since both sheets should shows the same data format.

    Note : This actually link the data in the Source Sheet to the Summary Sheet.
    The linked data will be intact if the data in the source sheet is not change or remove, otherwise you get a different value or a #REF
    in the Summary sheet.

    regards
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

Posting Permissions

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