Prev: open workbook to specific sheet
Next: How do I stop Excel from automatically resizing my row height?
From: Louise on 9 Apr 2010 11:14
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.
--
Louise
From: Dave Peterson on 9 Apr 2010 11:19
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.

Louise wrote:
>
> 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.
> --
> Louise

--

Dave Peterson
From: trip_to_tokyo on 9 Apr 2010 11:41
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.



"Louise" wrote:

> 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.
> --
> Louise
From: Louise on 9 Apr 2010 12:48
Thank you Dave! My problem was I had it marked text. You made it so simple!
--
Louise


"Dave Peterson" wrote:

> 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.
>
> Louise wrote:
> >
> > 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.
> > --
> > Louise
>
> --
>
> Dave Peterson
> .
>
 | 
Pages: 1
Prev: open workbook to specific sheet
Next: How do I stop Excel from automatically resizing my row height?