Results 1 to 3 of 3

Thread: Link same cells across multiple sheets

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member
    Join Date
    May 2020
    Posts
    66
    Rep Power
    6

    Link same cells across multiple sheets

    In the worksheet attached here (please see the attachment), there are total 82 sheets.
    1st Sheet, Master sheet, contains a list of 80 names.
    2nd sheet is "Case", and remaining 80 sheets are 1, 2, 3.....80.

    I want to link each name of the list in Master Sheet with the same cells of each corresponding sheet,
    that is,
    the name in cell B2 should appear in cell C3 of sheet 1
    similarly, value of B3 in cell C3 of sheet 2
    similarly, value of B4 in cell C3 of sheet 3
    and so on

    Only the 2nd sheet 'Case' should be remain unaffected

    ...................................

    I can link by using the formula ='Master Sheet'!B2
    But I have to go to 80 sheets one by one and link each cell one by one, which is really takes lot of time.

    Is there any simple method or vba to solve this problem??

    Please help!!
    Attached Files Attached Files

Similar Threads

  1. Replies: 8
    Last Post: 06-01-2020, 06:13 PM
  2. Replies: 2
    Last Post: 02-27-2019, 05:35 PM
  3. Replies: 8
    Last Post: 12-05-2017, 03:20 PM
  4. Replies: 9
    Last Post: 08-23-2013, 04:25 PM
  5. Vlookup - Multiple Sheets
    By Suhail in forum Excel Help
    Replies: 3
    Last Post: 01-30-2013, 06:47 PM

Posting Permissions

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