Drop down look up table

August 29, 2009 at 13:55:35
Specs: Windows XP

I have an excel application to produce invoice and a packing sheet that I have built over the years. It also exports data to an access database from which sales figures can be obtained.

The excell sheet uses a a lookup function to pick up values like title, price, index numbers etc from a Booklist.xls file. The link key is the product_id. So by inputting the prod_id value pulls up into the invoice line all the other required values.

What I want to find out now is if I can use the Booklist.xls as a lookup table while it is closed so that in the incoice.xls file, clicking in the product_id cell brings up a table showing product_ids along with product titles from the booklist, and I can scrol down and pick the one I need. Instead of having to remember id product_id or having to open the booklist file to see it.

Can this be done? How do I do it? If anyone has any ideas or has done something similar to it, I will be grateful for their wisdom and help.



See More: Drop down look up table

Report •

August 29, 2009 at 15:25:32
You'll get a better response if you post your question the the Office Software forum.



Report •
Related Solutions

Ask Question