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

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

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 and it will always refer to that cell

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

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

Originally Posted by Jim

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

goto tools=options=uncheck zero values