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!!




Reply With Quote
Bookmarks