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