Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Duplication of data ranges in other worksheets (2000)

    Large screenshot reduced in size by HansV. No pictures over 640x480 please.

    I would like to know how to insert a named range from one worksheet into anther.
    As l have to duplicate the same information from one work sheet to 14 other worksheets.
    see screenshot.
    The data range being "DAPU"

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

    Re: Duplication of data ranges in other worksheets (2000)

    You can copy the range, then select the 14 other worksheets (click on the sheet tab of the first one, Shift+click on the sheet tab of the last one), and paste.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplication of data ranges in other worksheets

    I tried this and it did not worik,
    i.e it did not paste correctly?
    It would not allow me to paste, reason being paste is not highlighted.
    I clicked on the label range then clicked on shift and clicked on the sheet and for for some reason paste was not highlighted, see screenshot.

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

    Re: Duplication of data ranges in other worksheets

    Did you copy the source range before trying to paste?
    - Select the source range.
    - Select Edit | Copy.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplication of data ranges in other worksheets

    Thats great thanks.

Posting Permissions

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