Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with Excel Extraction
Hi Can anyone please help? How do I do the following: I would like to extract information based on the following criteria. We open excel up and the first screen opens with 6 headings showing: Setting goals and objectives Marketing Manpower planning Financial matters Performance review Business planning I then choose to click on say the ‘Marketing box’ which I want it to automatically open a new screen with say 7 predetermined boxes [i.e. previously defined for inclusion within the marketing box] showing: PR Sales Market research Competitor review Direct marketing Networking Advertising I then click on the sales box and I want it to automatically opens a new screen with say 23 predetermined boxes showing: Overcoming objections Closing the sale Sales letter writting etc with another optional 19 boxes I then click on the Overcoming objections box and want it to open and there is a boxed list setting out the ways in which one can overcome objections in sales presentation Jump on their heads Shout at them Threaten them with violence Etc. Etc. Many thanks Yvonne -- YvonneSmythe ------------------------------------------------------------------------ YvonneSmythe's Profile: http://www.excelforum.com/member.php...o&userid=26759 View this thread: http://www.excelforum.com/showthread...hreadid=400133 |
#2
|
|||
|
|||
You might find dependent data validation lists helpful. Check out Debra
Dalgliesh's website http://www.contextures.com/xlDataVal02.html "YvonneSmythe" wrote: Hi Can anyone please help? How do I do the following: I would like to extract information based on the following criteria. We open excel up and the first screen opens with 6 headings showing: Setting goals and objectives Marketing Manpower planning Financial matters Performance review Business planning I then choose to click on say the €˜Marketing box which I want it to automatically open a new screen with say 7 predetermined boxes [i.e. previously defined for inclusion within the marketing box] showing: PR Sales Market research Competitor review Direct marketing Networking Advertising I then click on the sales box and I want it to automatically opens a new screen with say 23 predetermined boxes showing: Overcoming objections Closing the sale Sales letter writting etc with another optional 19 boxes I then click on the Overcoming objections box and want it to open and there is a boxed list setting out the ways in which one can overcome objections in sales presentation Jump on their heads Shout at them Threaten them with violence Etc. Etc. Many thanks Yvonne -- YvonneSmythe ------------------------------------------------------------------------ YvonneSmythe's Profile: http://www.excelforum.com/member.php...o&userid=26759 View this thread: http://www.excelforum.com/showthread...hreadid=400133 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |