View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default 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.