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