formulas between worksheets
If Sheet1 A1 is blank, the formula will return a 0
To trap for that..........=IF(Sheet1!A1="","",Sheet1!A1)
Gord Dibben MS Excel MVP
On Thu, 27 Mar 2008 05:27:00 -0700, ollie
wrote:
thankyou so much
This formula on any sheet would make the cell equal to Sheet 1 A1
=Sheet1!A1
Mike
"ollie" wrote:
could any body tell me if it is possible to create a formula that allows you
for example to input a number in worksheet 1 and for that number to
automatically appear in worksheet 2?
|