(Msg. 1) Posted: Thu Mar 27, 2008 5:05 am
Post subject: formulas between worksheets Archived from groups: microsoft>public>excel>newusers (more info?)
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?
(Msg. 2) Posted: Thu Mar 27, 2008 5:13 am
Post subject: RE: formulas between worksheets [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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?
(Msg. 3) Posted: Thu Mar 27, 2008 5:27 am
Post subject: RE: formulas between worksheets [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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?
(Msg. 4) Posted: Thu Mar 27, 2008 3:38 pm
Post subject: Re: formulas between worksheets [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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 <ollie.DeleteThis@discussions.microsoft.com>
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?
(Msg. 5) Posted: Mon Sep 14, 2009 9:33 am
Post subject: RE: formulas between worksheets [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office