Return multiple values from a list (filling a form)

mjb521

New Member
Joined
Dec 23, 2005
Messages
1
I created a spreadsheet that i use in my restaurant for catering jobs.
We have many of the same customers, and go to the same places very often.

I want to select "Customer A" from some type of list (on a secondary Worksheet)and have all of his data pulled into 4 or 5 cells of my Primary worksheet.

Specifically, I want to have a "database" in Sheet2 that I can periodically update. When I select "Customer A" from a list (generated from Sheet2 database) I want to fill in (Cells B2, B3, B4) on Sheet1 with Phone Number, Mailing Address and credit card number as an example.

Once my order form (sheet1)has been filled, it generates another worksheet (sheet3) that has a checklist and invoice filled in with all the relevant data. The checklist is customized - based on the data we input on Sheet1 (Order Sheet). I have a couple command buttons that run macros to save this Template as "Name.date.location". This allows me to find the data when any given customer calls back - or if we are delivering to the same location. I have spent many hours scouring web pages and Microsoft office tutorials etc., but I cannot get on the right track.

I am a self taught novice in excel, but have played around a bit with list boxes, macros, command buttons etc., and I think I should be able to make this work. I have no formal VBA training. Running WinXP and excel2003.

My life would be so much easier if I could open my "Catering Template.xls" and select "Customer A" from a list and have it fill in Address and telephone information automatically. I probably have a customer base of about 50 people and we go mainly to the same 20-30 locations.

If anyone has some "basic" tips, I would appreciate it greatly.

Thanks
MB
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

jindon

MrExcel MVP
Joined
Aug 21, 2004
Messages
16,995
Sounds like typical VLookup function situation

refer excel help for "vlookup" for details
 

Watch MrExcel Video

Forum statistics

Threads
1,122,995
Messages
5,599,256
Members
414,299
Latest member
thenewworld

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