|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 27th, 2008, 12:05 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
formulas between worksheets
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? 
|
|
#2
March 27th, 2008, 12:13 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formulas between worksheets
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?
|
|
#3
March 27th, 2008, 12:27 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formulas between worksheets
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?
|
|
#4
March 27th, 2008, 10:38 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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?
|
|
#5
September 14th, 2009, 05:33 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formulas between worksheets
Ok I have a problem. I have this formula which I need to look in another
column AF for the date and calculate by date. I have the following for the year to date or =COUNTIF(Projects!N:N,"REJECTED")+COUNTIF(AR!N:N," REJECTED")+COUNTIF(Legal!N:N,"REJECTED") Can anyone assist? "Mike H" wrote: 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
