View, scroll and select a cell value from another Excel sheet?
 

I have created an estimating spreadsheet. It looks to other excel data files
for data imported from our business system (Stock file, Customer file) At the
moment I use VLOOKUP to lookup values after the user types in a code for the
stock or customer. My users have a hard copy of the stock and customer lists
so they can find the exact code they need to enter.
I would like the ability to search the data file to select the code to be
used - from within the active cell in my estimate sheet. Then use VLOOKUP to
complete the result.
How can this be done?

View, scroll and select a cell value from another Excel sheet?
 

Hi

If I have understood your requirement, you need a dropdown for the user
to select the code.
Take a look at Debra Dalgleish's site on Data Validation and you will
see lots of ways of achieving this.
http://www.contextures.com/xlDataVal01.html

--
Regards

Roger Govier


"benb" wrote in message
...
I have created an estimating spreadsheet. It looks to other excel data
files
for data imported from our business system (Stock file, Customer file)
At the
moment I use VLOOKUP to lookup values after the user types in a code
for the
stock or customer. My users have a hard copy of the stock and customer
lists
so they can find the exact code they need to enter.
I would like the ability to search the data file to select the code to
be
used - from within the active cell in my estimate sheet. Then use
VLOOKUP to
complete the result.
How can this be done?