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.