How do I enter info on 1 worksheet and have it appear on another .

[Curtis- Dallas]

How do I enter information/formulas in 1 cell on a worksheet and have the
results post in another worksheet as well as in the original worksheet?

 

[Frank Kabel]

Hi
use a formula such as:
='sheet1'!A1
on your second sheet to 'pull' the value from cell A1 on your first
sheet

 

[John A Hansen]

Frank:

That would work would work for "pulling" a value into a
formula but I havn't been able to get that to actually enter the
information ( ala a sales person name or address) into the
second sheet.

I would love to be corrected and find that that's it merely
something that I'm overlooking . I've had to use copy and
paste for each item.

Best Regards
John A Hansen

 

[Frank Kabel]

Hi John
now I'm a little bit confused
The only thing you can do is enter such a formula in the TARGET
location to
pull the data from another cell to this target location (without the
formats
though). So maybe you can describe exactly (with cell references) where
you
want to enter your information and where this information should be
displayed