Results 1 to 2 of 2

Thread: 3D referencing of a range over multiple tabs

  1. #1

    3D referencing of a range over multiple tabs

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Everyone,

    I was trying to select multiple identical tabs in an excel and reference a range of names to show in each tab.

    the range would be


    And the same cell on each of those tabs would show Apple on the first and Orange on the second and Kiwi on the third.

    Dont know if I was clear. Thanks for the help



  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    If i understand correctly and you simple want to copy those cells the multiple sheets, then first copy the range... then select the first of the sheets you want to copy to, hold the Shift key down, then select the last sheet you want to copy to. Now paste the range where you want. You can right click any sheet and choose to ungroup sheets when done (or select a sheet you hadn't selected in the copy to range).

Posting Permissions

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