software

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

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

hth
Vaya con Dios,
Chuck, CABGx3
quot;Jimquot; wrote:

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


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

goto
insert=gt;name=gt;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 and it
will always refer to that cell--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=517425It 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

quot;CLRquot; wrote:

gt; You would need VBA to do that...........the details of which would be
gt; specific to your application.
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Jimquot; wrote:
gt;
gt; gt; I would like to input a clients name on one sheet and have that cell data
gt; gt; placed automaticly at a specified location on other sheets within the
gt; gt; workbook. Can this be done using a function or do I need to think of
gt; gt; something else? Any help would be great.
gt; gt;
gt; gt; 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?

quot;Elkarquot; wrote:

gt; It might not be that complicated, depending on your needs. Would a simple
gt; cell reference be adequate?
gt;
gt; In your destination cell, enter the formula:
gt;
gt; ='Sheet Name'!A1
gt;
gt; Where 'Sheet Name' is the name of the Sheet containing the input data. And
gt; A1 is the cell where the data is input. Seperated with an exclamation point.
gt; The single quotes are only necessary if there is a space in your sheet name.
gt;
gt; HTH,
gt; Elkar
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; You would need VBA to do that...........the details of which would be
gt; gt; specific to your application.
gt; gt;
gt; gt; hth
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Jimquot; wrote:
gt; gt;
gt; gt; gt; I would like to input a clients name on one sheet and have that cell data
gt; gt; gt; placed automaticly at a specified location on other sheets within the
gt; gt; gt; workbook. Can this be done using a function or do I need to think of
gt; gt; gt; something else? Any help would be great.
gt; gt; gt;
gt; gt; gt; Jim


Jim Wrote:
gt;
gt; possible to get rid of the '0' value when there is no input on the
gt; reference
gt; cell?
gt;
gt;
goto tools=options=uncheck zero values--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=517425