Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
HEATHERCOX
 
Posts: n/a
Default 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 :-)
  #2   Report Post  
PCLIVE
 
Posts: n/a
Default

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 :-)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrap text limits in Excel 2003 cell formatting Adelrose Excel Discussion (Misc queries) 1 April 19th 05 06:32 PM
Why doesn't text wrap in a cell in Excel? rohrbaught Excel Discussion (Misc queries) 6 April 8th 05 06:13 PM
Paste Link enters a 0 into the cell where I paste. How do I elemin UNR Excel Discussion (Misc queries) 4 March 28th 05 01:54 AM
How to reference a text cell that changes weekly in Header or Foo. duane Excel Discussion (Misc queries) 2 March 20th 05 02:31 PM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 07:12 PM


All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"