Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I update a spreadsheet with numbers input into another?
How do I link two speadsheets in order to update both at the same time?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I update a spreadsheet with numbers input into another?
"Duma" wrote:
How do I link two speadsheets in order to update both at the same time? Probably something like this In Sheet2, In A1: =IF(Sheet1!A1="","",Sheet1!A1) Copy A1 across/down to cover the extent Sheet2 will then reflect entries/updates in Sheet1 for the formulated range -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I update a spreadsheet with numbers input into another?
If both spreadsheets are the same, headers, data ranges, titles etc,
basically same architecture on both sheets, then... While on Sheet1, hold the shift key down, click Sheet2, now both are highlighted. Now your sheets are "Grouped". anything you do on one, will be applied to the other, including print page set ups. Practice, be careful doing this as you can accidentally key something in all sheets and not intend to while they are grouped. Very handy though to set page set up same in all sheets quickly. Does that help? "Max" wrote: "Duma" wrote: How do I link two speadsheets in order to update both at the same time? Probably something like this In Sheet2, In A1: =IF(Sheet1!A1="","",Sheet1!A1) Copy A1 across/down to cover the extent Sheet2 will then reflect entries/updates in Sheet1 for the formulated range -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input numbers appearing incorrectly on spreadsheet | Excel Discussion (Misc queries) | |||
Automatically update spreadsheet from another spreadsheet | Excel Worksheet Functions | |||
Drop Down--How do I copy and update cell link/input range | Excel Discussion (Misc queries) | |||
Combo Box input range automatic update | Excel Discussion (Misc queries) | |||
Why don't fields update automatically when new numbers are input?. | Excel Discussion (Misc queries) |