![]() |
|
|||||||
|
|
|
|
|
|
Hi,
I'm doing a spreadsheet project at the moment which is a Quoting system in effect (Once I get it going).
I have combo boxes from which the data comes from another sheet. I have set the cell link and all, but when I click on a option, it comes ...
|
![]() |
|
|
Thread Tools |
|
#1
|
|||
|
|||
|
Hi,
I'm doing a spreadsheet project at the moment which is a Quoting system in effect (Once I get it going). I have combo boxes from which the data comes from another sheet. I have set the cell link and all, but when I click on a option, it comes up with the numbers '1', '2', '3' etc. I want it to come up with the price of the product. Any help would be appreciated. This is early stages of the project at the moment. But I can paste screenshots if necessary. Jon |
|
#2
|
||||||||||||
|
||||||||||||
|
do you have it set to currency? do you have it linked properly?
__________________
Best case would be to post the sheet (with false info if you don't want people to have it) and then explain what you want My System: hAvAAck Build 3
|
|
#3
|
|||
|
|||
|
Here is the attachment!
Many thanks in advance! |
|
#4
|
||||||||||||
|
||||||||||||
|
Hi
Instead of using the Forms toolbar controls, use the Control Toolbox controls - you'll have more properties to choose from and more control. I've created one new combobox on your sheet - choose a product and the price appears in the cell next to it. I've named your price list range, A2:B11 as List - using a Named Range is easier. Then, in the combobox properties, change the Bound Column to 2, the ListFillRange to the newly Named Range and the LinkedCell to whatever suits. By changing the BoundColumn to 2, you are effectively doing a lookup on the list of products and prices. Hopefully that should give you a start and some ideas. My System: It's all mine...
|
|
#5
|
|||
|
|||
|
|
|
#6
|
|||
|
|||
|
hey,
my post links into Jonathon's post as it is a similar project. I need a formula which will increase the number by 1 every time a quote is saved. For example customer no. is 1 atm, after this quote has been saved, the number will go upto 2 and so on. |
|
#7
|
||||||||||||
|
||||||||||||
|
__________________
__________________
serverguy My System: Eclipse
|
![]() |
|
| Bookmarks |
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Asus Maximus II Formula PC build | mizsua | CPUs, Motherboards & RAM | 7 | 9th Jan 2009 16:44 |
| Help with Excel formula please | robbie73 | Office Suites & Applications | 2 | 10th Sep 2008 11:00 |
| Excel Formula - VLookups :s | Jonathon28 | Office Suites & Applications | 1 | 1st May 2008 12:14 |
| =IF formula | Jonathon28 | Office Suites & Applications | 5 | 17th Feb 2008 09:10 |
| Asus Striker 2 Formula, some questions | codymackay | CPUs, Motherboards & RAM | 5 | 10th Feb 2008 17:24 |
| Thread Tools | |
|
|