| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying columns and automating data updates across worksheets
Sheet #1 is the core worksheet. Other sheets will draw from Sheet #1. For
example, I would like to know how I can set up Sheet #2 so that Columns A, B, C and D will always be the same as Columns A, B, C and D on Sheet #1. So, if I add a row to Sheet # 1 or I change the data in a cell or cells in Columns A, B, C, and/or D of Sheet #1, those changes should automatically appear in Sheet #2. I have tried references and links, but if I insert a row to Sheet #1, Sheet #2 does not reflect the change. Any ideas? THANKS. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Columns to table | Excel Worksheet Functions | |||
| Automating a series of dates for two columns? | Excel Worksheet Functions | |||
| Automating charts with reference to new data and formulas | Excel Worksheet Functions | |||
| Automating Linear Interpolation | Excel Discussion (Misc queries) | |||
| allow user to disable annoying warning dialog on log charts | Charts and Charting in Excel | |||
Threaded Mode
