Home |
Search |
Today's Posts |
#1
|
|||
|
|||
lists w/ multiple worksheets q
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functions across multiple worksheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
multiple worksheets input to one | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |