L Louise Apr 9, 2010 #1 how do i get excel to read ='sf-14'!ag13 as a formula. i want the value from one worksheet to appear on another worksheet.
how do i get excel to read ='sf-14'!ag13 as a formula. i want the value from one worksheet to appear on another worksheet.
D Dave Peterson Apr 9, 2010 #2 Make sure that the cell that gets that formula is formated as General (or anything but Text). Then re-enter the formula. You may want: =if('sf-14'!ag13="","",'sf-14'!ag13) Then if AG13 on sf-14 is empty, you won't see a 0.
Make sure that the cell that gets that formula is formated as General (or anything but Text). Then re-enter the formula. You may want: =if('sf-14'!ag13="","",'sf-14'!ag13) Then if AG13 on sf-14 is empty, you won't see a 0.
T trip_to_tokyo Apr 9, 2010 #3 EXCEL 2007 Hi Louise. Simple example. In Sheet 1 cell A1 I type the number 1 In Sheet2 cell A1 (this can be any sheet / cell you like) I type:- =Sheet1!A1 This pulls in the data from Sheet 1 cell A1. If my comments have helped please hit Yes. Thanks.
EXCEL 2007 Hi Louise. Simple example. In Sheet 1 cell A1 I type the number 1 In Sheet2 cell A1 (this can be any sheet / cell you like) I type:- =Sheet1!A1 This pulls in the data from Sheet 1 cell A1. If my comments have helped please hit Yes. Thanks.
