I have a workbook with seven worksheets. I want to link one row on the 1st sheet to subsequent rows on different sheets.
Sheet 1
Row 110
Column A
to
Sheet 2
row 49
columns A:k
thanks!
I have a workbook with seven worksheets. I want to link one row on the 1st sheet to subsequent rows on different sheets.
Sheet 1
Row 110
Column A
to
Sheet 2
row 49
columns A:k
thanks!
Hi
if you grouped the other worksheets together, highlight the tabs (select first and last sheet holding shift), then go to cell row 49 (on whichever sheet is highlighted), type "=" then select the first cell on sheet 1, it'll then populate on all worksheets.
You can then either fill right, or if it needs to be the same cell ref, anchor the Sheet1!A110 by adding sheet1!$A$110
Adi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks