Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() This sounds like a great idea. However the cells that I will be pulling from are not static. I want to look up a customer from row 27 with SSN: xxx-xx-xxxx, and then maybe I will look up the next customer on row 45. with ssn: xxx-xx-xxx2. How can I set the control source to a different cell based upon which customer I look up. All of the SSN's will be from the same column, but each ssn is on a diff. row. WILL A CONTROL SOURCE WORK? OR IS THERE A ANOTHER SOLUTION? Mike -- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=274237 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Copy data into a NEW worksheet | Excel Discussion (Misc queries) | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
VBA: Update worksheet when txtBox data changes. | Excel Worksheet Functions |