Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to - Quote Sheet ?
Hi, this is my first post, been reading for about 30 mins, looks like a great resource! Anyways, I did a few searches and couldnt find what i was looking for, so I am posting.. I have a list of products with prices and a bit of info. I want to organize this a bit better to make it easier and more professional like to create quotes for clients. I have seen some excel sheets where there is a little dorp down box, you select and then fields are filled in. I am after something quite simple, like a list of procducts with prices, and then just client details..I would then select, and print to Adobe PDF. Any tutorials on how to do this, drop down menu system, is it a pivot table? I guess what i want in a way, is a mini DB which will call on data when I select a name or product. Well I await your comments peeps. Cheers in advance Mike -- mukcl ------------------------------------------------------------------------ mukcl's Profile: http://www.excelforum.com/member.php...o&userid=36599 View this thread: http://www.excelforum.com/showthread...hreadid=563425 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to - Quote Sheet ?
mukcl Wrote: Hi, this is my first post, been reading for about 30 mins, looks like a great resource! Anyways, I did a few searches and couldnt find what i was looking for, so I am posting.. I have a list of products with prices and a bit of info. I want to organize this a bit better to make it easier and more professional like to create quotes for clients. I have seen some excel sheets where there is a little dorp down box, you select and then fields are filled in. I am after something quite simple, like a list of procducts with prices, and then just client details..I would then select, and print to Adobe PDF. Any tutorials on how to do this, drop down menu system, is it a pivot table? I guess what i want in a way, is a mini DB which will call on data when I select a name or product. Well I await your comments peeps. Cheers in advance Mike These drop down menus in excel are from Data Validation lists. Try http://www.contextures.com/tiptech.html as it has several examples of how to use Data Validation. Scott -- Maistrye ------------------------------------------------------------------------ Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078 View this thread: http://www.excelforum.com/showthread...hreadid=563425 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to - Quote Sheet ?
In addition to the DV drop-downs you will want some VLOOKUP formulas to fill in
the fields corresponding to the picked item from the drop-down. Can be found at same site as DV instructions pointed to by Maistrye http://www.contextures.on.ca/xlFunctions02.html Gord Dibben MS Excel MVP On Thu, 20 Jul 2006 14:19:51 -0400, Maistrye wrote: mukcl Wrote: Hi, this is my first post, been reading for about 30 mins, looks like a great resource! Anyways, I did a few searches and couldnt find what i was looking for, so I am posting.. I have a list of products with prices and a bit of info. I want to organize this a bit better to make it easier and more professional like to create quotes for clients. I have seen some excel sheets where there is a little dorp down box, you select and then fields are filled in. I am after something quite simple, like a list of procducts with prices, and then just client details..I would then select, and print to Adobe PDF. Any tutorials on how to do this, drop down menu system, is it a pivot table? I guess what i want in a way, is a mini DB which will call on data when I select a name or product. Well I await your comments peeps. Cheers in advance Mike These drop down menus in excel are from Data Validation lists. Try http://www.contextures.com/tiptech.html as it has several examples of how to use Data Validation. Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |