Pulldown List to open Workbook.

[lukus2005]

I have a supplier who updates his pricelist via several spreadsheets.
I want to create an interface so that I may access the appropriate
pricelist (workbook) by simply selecting the proper category from a
pulldown menu (list).

So basically, if I select "Piping" from the pulldown menu, it would
open "Piping.xls" either within my main workbook or by itself.

I have no macro experience so I was hoping I could do this without
using them... is this possible?

 

[Jim Cone]

Opening a workbook from a dropdown box requires a macro.
You could, however, create a list of links to your workbooks (on a worksheet)
and open a workbook by simply clicking the link.

Use a hyperlink formula for each workbook you want to open...
=HYPERLINK("C:\Program Files\Microsoft Office 2003\Sludge.xls","Sludge.xls")
-or-
Use the "Hyperlink..." menu item from the Excel Insert menu.
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ListFiles
(excel add-in to automatically list files)

..
..
..

<[email protected]>
wrote in message
I have a supplier who updates his pricelist via several spreadsheets.
I want to create an interface so that I may access the appropriate
pricelist (workbook) by simply selecting the proper category from a
pulldown menu (list).

So basically, if I select "Piping" from the pulldown menu, it would
open "Piping.xls" either within my main workbook or by itself.

I have no macro experience so I was hoping I could do this without
using them... is this possible?

 

[lukus2005]

Thanks Jim! Not the way I had envisioned but it certainly does
accomplish what I wanted.