I am not sure if it is actually called a lookup table, but I will explain what I am trying to accomplish. I have a list of data that contains several columns of information such as an item name, description, weight, and price. After the data list is created, I want to be able to easily create several excel spread sheets using only items from the data list in a way that would allow me to say click the first cell of a row which in turn would bring up the data list, and then clicking on one of the items in the data list would fill that data into the excel spread sheet row. Is this possible in excel or a combination of access and excel?
Bookmarks