I need excel help

C

casadegeorge

To whom may read,

I'm currently using Excel 2000. I'm wanting to either create a address
book via Excel or import address information via a microsoft office
program into an established excel file. I've created a purchasing
templete for my use in at my current company. Using this purchasing
templete I've created many different templetes for different vendors.
My question is can I create a pull down bar that would list my vedors
individually, select a given vendor and the information from the
selected vendor, and all that information be pulled up on the original
purchasing templete. (example address information)

If you can advice me in all my confussion, please do.

Helpless in Knoxville
 
J

Jim

If you currently use Outlook for your address book, you may export the file
to an XL file from within Outlook.
 
R

RagDyer

Debra Dalgleish has a web page that can instruct you on how to create a drop
down list that will enable you to do what you wish.

http://www.contextures.com/xlDataVal01.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
C

casadegeorge

Thank you for your help. Although I'm a little confussed when writing
my formula. Could someone help me out with this? I've attached my XL
file for anyone to look at. My problem is with cell A13. I'm wanting
to continue my address in the following cell, with my information
provided on Sheet 1. I hope this makes since.

File Attached: http://www.exceltip.com/forum/attachment.php?postid=312306 (purchase order.xls)
 
R

RagDyer

Can anyone educate me as to how to view all these WBs that the OPs from
exceltip are linking to these groups ?
--


Regards,

RD
 
Top