how can i update information from one work sheet to another without opening the other worksheets?
M Moh Jan 28, 2008 #1 how can i update information from one work sheet to another without opening the other worksheets?
D David Biddulph Jan 28, 2008 #2 =Sheet1!A2 If you want the cell to be blank if the original cell is blank, then try =IF(Sheet1!A2="","",Sheet1!A2)
=Sheet1!A2 If you want the cell to be blank if the original cell is blank, then try =IF(Sheet1!A2="","",Sheet1!A2)
G Gord Dibben Jan 28, 2008 #3 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
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
