In a workbook, there is a summary sheet and the same cell(C5) of the following sheets, will successively quote the value in Row9 of summary.
i.e C5 in sheet2 = B9, C5 in Sheet3=C9 etc.
And how to use VBA to realize this?
Thks!