I am trying to create what I think is a strange spreadsheet and at this
point I do not even know if it is possible. I have 3 worksheets that I
have named database, GUI, & totals. The database sheet contains a a
number of rows about a item the user can select. The first column is
the name and the next 10 or so columns are specific information about
that item. The GUI worksheet has a new row for each day. Then I
created a list of all the items in the database worksheet. The user
can then on the GUI worksheet select a number of different items from
the list (each item is a different column for a specific date). Now
this is where I get lost. My third worksheet I want to total up some
of the properties from each item the user selected for the day. For
example, for 9/28/05 the user selects ITEM1, ITEM3, & ITEM5 from the
lists. So now I want in the total sheet the price of all three items.
I know what item in the list was selected but how do I get the price of
that item off the database worksheet? Is this possible?


--
theqcup
------------------------------------------------------------------------
theqcup's Profile: http://www.excelforum.com/member.php...o&userid=27636
View this thread: http://www.excelforum.com/showthread...hreadid=471551