I have set up a "data" workbook which contains several worksheets. Each worksheet contains different data (all in same array format). I then have another "Input" workbook which uses data validation techniques to pull data (via drop down lists) from the "data" workbook. I have locally named the data ranges in the "data" workbook to accomplish this. One set of information I am pulling over has the cell format: ="Plate, 1/4 x "&E1&" (4x10)". Basically, I am trying to reference cell "E1" within the "Input" workbook so that when the value is pulled from the "data" workbook, it fills in with the contents of E1. It would look something like this: Plate, 1/4" x 3" (4x10), with 3" being the E1 value. Anyone got any suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How do I reference a cell and use data validation?
- Thread starter nmc-timb
- Start date
I downloaded Colo's HTML Maker and was unable to get it to function (it could not find library). I am still on Excel 97 if this makes a difference.
Basically I am pulling data from a cell in another workbook which has a cell reference embedded in it. When I pull it into the current workbook I want it to recognize the cell reference in the current workbook and fill the data in from that cell in the current workbook.
Basically I am pulling data from a cell in another workbook which has a cell reference embedded in it. When I pull it into the current workbook I want it to recognize the cell reference in the current workbook and fill the data in from that cell in the current workbook.
Upvote
0
Similar threads
