forwarding cell data

J

Jim

I would like to input a clients name on one sheet and have that cell data
placed automaticly at a specified location on other sheets within the
workbook. Can this be done using a function or do I need to think of
something else? Any help would be great.

Jim
 
C

CLR

You would need VBA to do that...........the details of which would be
specific to your application.

hth
Vaya con Dios,
Chuck, CABGx3
 
D

davesexcel

the cell that you intend to input a name should be named itself

goto
insert=>name=>define
for this example type in client (it can only be a one word name eg:
MyClient)
at the bottom of the box click on the entry box and then select the
range that you want named

now everywhere in the workbook that name will refer to that range(cell)
in other sheets all you do is type =client in a cell :rolleyes: and it
will always refer to that cell
 
E

Elkar

It might not be that complicated, depending on your needs. Would a simple
cell reference be adequate?

In your destination cell, enter the formula:

='Sheet Name'!A1

Where 'Sheet Name' is the name of the Sheet containing the input data. And
A1 is the cell where the data is input. Seperated with an exclamation point.
The single quotes are only necessary if there is a space in your sheet name.

HTH,
Elkar
 
J

Jim

Thank you for the input that worked great. I have one more question is it
possible to get rid of the '0' value when there is no input on the reference
cell?
 
Top