| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy 1 document and when original updated copy is also
How do i get a copied excel document ( 46 lines in total) updated whenever
the original document is updated. Please HELP! I have a excel spreadsheet that i would like to use most of the data from to produce another spreadsheet that i can use to forecast for the next financial year and cannot remember how to link the two together so that whenever any changes are made on the Unit sheet (original document) it is automatically updated on my forecast sheet. I know roughly how to link but dont know how do link a whole spreadsheet or 46 rows of data. Can anyone please advise. many Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy the formatted value and paste as a new value(not the original value with formatting)? | Excel Discussion (Misc queries) | |||
| A copy of a chart doesn't change when the original has new range | Charts and Charting in Excel | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| How can I copy many formulas and keep original cell location? | Excel Discussion (Misc queries) | |||
| How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) | |||
Threaded Mode
