Customer Database Drop Down - AAARRRGGHH!!!!!!

thedonkey68

New Member
Joined
May 30, 2015
Messages
1
Hi there and hope someone can help me.

I've created a quotation sheet for my business for my customers - i have to type out their details everytime I create a quote.
I've searched high and low on the web to see how I can create a simple customer database sheet with their names and addresses so that my "quote" sheet can have a drop down and there is all my customers.

I'm finding it extremely difficult to get any help in how the hell you create a database with names and addresses - all i can see is single column lists which is great if you want individual items but i need to have this (customer name) and their address details in the box(es) below.

Hopefully this makes some kind of sense(!) and would be forever grateful if someone can show me how to do this fast and effectively.

Any help would be great.

Hope to hear from you guys soon.

thedonkey68
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

L. Howard

Well-known Member
Joined
Oct 16, 2012
Messages
4,514
If you have a workbook with a starter version of what you want to do, you could post a link here and folks can see what you want.

Include details about what you want and where you want it and of course include some "dummy customer info" to give a hint what sort of datra is being manipulated.

I use Drop Box for posting links, but there are others.

Howard
 

powercell99

Board Regular
Joined
May 14, 2014
Messages
75
Hi, the way i would handle this would be to create a customer table, then in the "quote" sheet use a dynamic dropdown list to reference the customer name field only, and use index/match formulas to match the customer name selected in the dropdown list to populate the rest of the fields needed in the "quote" sheet.

Larry


for the
Hi there and hope someone can help me.

I've created a quotation sheet for my business for my customers - i have to type out their details everytime I create a quote.
I've searched high and low on the web to see how I can create a simple customer database sheet with their names and addresses so that my "quote" sheet can have a drop down and there is all my customers.

I'm finding it extremely difficult to get any help in how the hell you create a database with names and addresses - all i can see is single column lists which is great if you want individual items but i need to have this (customer name) and their address details in the box(es) below.

Hopefully this makes some kind of sense(!) and would be forever grateful if someone can show me how to do this fast and effectively.

Any help would be great.

Hope to hear from you guys soon.

thedonkey68
 

Watch MrExcel Video

Forum statistics

Threads
1,130,047
Messages
5,639,763
Members
417,109
Latest member
996

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top