How do I link one TEXT cell to others in a worksheet and workbook.

H

HEATHERCOX

I'm trying to make a customers name pop up in every required field..can
anyone help???

Thank you!!

Heather :)
 
P

PCLIVE

If all the Name fields are cells (not text boxes), then you could link them
as follows:

If Customer Name is in A1:

Link all other cells that should only display the customer name by using
this formula

=$A$1


If by chance your required fields are Text Boxes, you would use the Linked
Cell option in the TextBox Properties and enter A1.


HTH,
Paul
 
Top