Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Urgent: How to bring data from another sheet into a droplist
Hi everyone, first post here. I have uploaded my excel file. it is 26kb http://members.optusnet.com.au/adrianloh01/Boots.xls I have a test tomz at uni, and i need to be able to bring data from another sheet (sheet 1) from a droplist box on another sheet (sheet 3). These are just sales figures for a motorbike boots (my assignment). I have made the drop downlist that has all the "sales agents" in it, but i need to know how to make it so when you click one "agent" the data comes from sheet 1 and brings up the relevant sales information. I have started putting the headings and needed columns on sheet 3. If anyone could help me here, i would really appreciate it. thanks, Ady -- bnr32 ------------------------------------------------------------------------ bnr32's Profile: http://www.excelforum.com/member.php...o&userid=26739 View this thread: http://www.excelforum.com/showthread...hreadid=399966 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Entering Data in multiple cells on one sheet & having it auto upda | Excel Worksheet Functions | |||
Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
How to populate one sheet with data from another sheet | New Users to Excel | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) |