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!
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!
See attached
- Battle without fear gives no glory - Just try
Thks for the reply but "C5 in Sheet3=C9 etc"
If you launch "CopyData" code it will be done.
Do you want this to happen automatically when writing data in "Summary" C9 ?
yes, I want this happen automatically.
And this has been solved.
Thks!
See attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks