"INDIRECT HELP OR SOMETHING SIMILAR"

  • Thread starter Thread starter Jim Badinger
  • Start date Start date
J

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
 
Hi Jim,

In the Computation worksheet enter this formula in B2:

=Conversion!B2

and copy down to B35.

Biff
 
Back
Top