| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to update
how can i update information from one work sheet to another without opening
the other worksheets? -- thank you |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to update
=Sheet1!A2
If you want the cell to be blank if the original cell is blank, then try =IF(Sheet1!A2="","",Sheet1!A2) -- David Biddulph "Moh" wrote in message ... how can i update information from one work sheet to another without opening the other worksheets? -- thank you |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to update
By "worksheet" do you actually mean "workbook" which contains worksheets?
See help on "linking to other workbooks" If you mean worksheet then see David's reply. Basically the same except you would be linking sheet references from two workbooks. =[Workbook1.xls]Sheet1!$A$1 Gord Dibben MS Excel MVP On Mon, 28 Jan 2008 09:56:02 -0800, Moh wrote: how can i update information from one work sheet to another without opening the other worksheets? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| i want to update one excel file the other one update automaticaly | New Users to Excel | |||
| keep value from last update and don't ask to update links | Excel Discussion (Misc queries) | |||
| Update Log | Excel Worksheet Functions | |||
| Update / don't update dialog box | Excel Worksheet Functions | |||
Linear Mode
