"INDIRECT HELP OR SOMETHING SIMILAR"

[Jim Badinger]

Hi,
I have two worksheets (same workbook-one worksheet
named Conversion and the other named Computation) that I
would liked to have certain data cells in one
automatically transfer and/or update in the other
(Conversion to Computation). I have tried several times
using INDIRECT and get very interesting results...not what
I want but interesting nonetheless. How does this work?

Example:

In the Conversion worksheet cells B2 thru B35 contain the
data I wish to have transfered to Computation cells B2
thru B35. I wish for the data type to maintain
integrity...that is to say numbers should be numbers and
text should be text.

Thanks again to the GURU's of Excel.

Signed,
Jim Badinger

 

[Biff]

Hi Jim,

In the Computation worksheet enter this formula in B2:

=Conversion!B2

and copy down to B35.

Biff

 

[Jim Badinger]

Biff,

-----Original Message-----
Hi Jim,

In the Computation worksheet enter this formula in B2:

=Conversion!B2

and copy down to B35.

Biff

.

 

[Jim Badinger]

Biff,
thanks a million! This is exactly what I needed!
Jim Badinger