View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default Repeat data on all sheets

My spreadsheet has 5 sheets. I want the contents of cell A1 to
be repeated on all 5 sheets.

So, for example, if a user changes A1 to "Claus" on Sheet 4
then the change should update A1 on all sheets. Or, if someone changes
A1 to "GS" on Sheet 1, then the change should update all sheets, etc....

I'm interested in all methods possible, whether using VBA code or
sheet formulas. (I might have asked a similar question long ago, so I
apologize if I repeated.)

Happy Halloween all!