ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I link one TEXT cell to others in a worksheet and workbook. (https://www.excelbanter.com/excel-worksheet-functions/22681-how-do-i-link-one-text-cell-others-worksheet-workbook.html)

HEATHERCOX

How do I link one TEXT cell to others in a worksheet and workbook.
 
I'm trying to make a customers name pop up in every required field..can
anyone help???

Thank you!!

Heather :-)

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



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

Thank you!!

Heather :-)





All times are GMT +1. The time now is 11:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com