How do I copy all cell data between sheets automaticaly?
The simplest way to do this is to "group" the sheets and make your
changes. When grouped, a change made to one sheet is made in the same
cell on the other grouped sheets.
Group sheets by pressing CTRL and left-clicking on the sheets you want
to group.
This may be a bit awkward for what you want to do, though, since you
may wind up grouping and ungrouping sheets frequently. The problem is
~ANY~ change made on one sheet is made on the others, so if you type or
delete data it will appear in all grouped tabs.
|