I need excel help

  • Thread starter Thread starter casadegeorge
  • Start date Start date
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
 
If you currently use Outlook for your address book, you may export the file
to an XL file from within Outlook.
 
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!
==============================================
 
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)
 
Can anyone educate me as to how to view all these WBs that the OPs from
exceltip are linking to these groups ?
--


Regards,

RD
 
Back
Top