| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat column in all sheets | Excel Discussion (Misc queries) | |||
| how to repeat text on sheets in excel | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Programming | |||
| Header repeat across Sheets? | Excel Discussion (Misc queries) | |||
![Robert Crandal[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
