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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thank you!!

Heather :-)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
want to create a link to another worksheet in another workbook 1
Linking a workbook to worksheets 1
Linking data from one worksheet to another... 2
Identical Cells in Multiple Worksheets in one Workbook. 4
Linking two cells of text together 3
How to sum one cell across workbook if nr of worksheets is variabl 2
Link cells with text not numbers 4

Back
Top