forwarding cell data
 

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

forwarding cell data
 

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

hth
Vaya con Dios,
Chuck, CABGx3



"Jim" wrote:

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

forwarding cell data
 

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517425

forwarding cell data
 

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

"CLR" wrote:

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

hth
Vaya con Dios,
Chuck, CABGx3



"Jim" wrote:

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

forwarding cell data
 

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?

"Elkar" wrote:

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

"CLR" wrote:

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

hth
Vaya con Dios,
Chuck, CABGx3



"Jim" wrote:

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

forwarding cell data
 

Jim Wrote:

possible to get rid of the '0' value when there is no input on the
reference
cell?


goto tools=options=uncheck zero values


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517425