Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2007
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combine Sheets for simultanious input (Excel 2003)

    In my code I am combining Sheet1, Sheet2, Sheet3 if the the active cell falls in a specified range.
    Here is my problem. Once the sheets are combined or selected I can enter data in Sheet1 and the information will populate in Sheet2 and Sheet3 in the same range. Then, I modify Sheet2 cell(1,1) with a value and go to Sheet1. Now the values in Sheet1 cell(1,1) = 1 and Sheet2 cell(1,1) = 2, which is okay. Now I select Sheet1 cell(1,1) and do a copy and paste in cells(1,2) and (1,3), during which the sheets are grouped. When i return to Sheet2 I see that the values in cell(1,2) and cell(1,3) are equal to 2 and not 1.
    Is there a way to group sheets and be able to use copy paste which will populate the sheets with the numbers modified in the active sheet?

    I hope I didn't confuse you.

    Thanks.

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

    Re: Combine Sheets for simultanious input (Excel 2003)

    I think you'll have to paste to each sheet separately, or write a macro to do so.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Combine Sheets for simultanious input (Excel 2003)

    The way that would be done without VBA would be to first copy the new values on the Top Active Sheet of your Group. Then Select the range of new values on the active sheet. Lastly, Choose Edit Fill Across Worksheets. When the dialog box opens selects All.

    To see the code just record a Macro doing the above and then modify lthe code to fit within your Macro.

    Good Luck

    Tom Duthie

  4. #4
    Lounger
    Join Date
    Jan 2007
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine Sheets for simultanious input (Excel 2003)

    Thank you Tom. This helped solving my problem.

Posting Permissions

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