Drop down menu and pasting from another Excel sheet-help

bob306

New Member
Joined
Jan 22, 2005
Messages
9
Hello,

I have an Excel sheet that I would like that when I click on a certain cell that a drop down menu will come up and allow me to pull certain data from another Excel sheet and paste it into the current cell. Basically I have a purchase order form that I want to paste a certain vendor name from a list of 200 vendors on a separate Excel file and put it into the purchase order form I'm working on, so that I can fax it.

Any help you can give will be appreciated, I have tried various things but none have helped, if you can give examples and codes it would help as I have a good basic knowledge of Excel but am far from an expert.

Thank You,

Bob306
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Dark RyNo

New Member
Joined
Jan 21, 2005
Messages
8
Well. Im not an Excel guru but I think I can help with the drop down box.
If you highligh the list of names, and then rename that list "Vendornames" or something. Then you go to the cell you want the menu on. Go to "Data" - "Validation" then choose "list" from the "settings" tab. Now, in the formula box, type "=vendornames" or whatever you called it. (without quotations)
Hope this helps.
 

Forum statistics

Threads
1,147,623
Messages
5,742,208
Members
423,712
Latest member
edzubur

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