<div>
Working good, thx a lot<br />
Points are yours.
</div>


Working good, thx a lot
Points are yours.

<div>
<div class="content wysiwyg-content">
Hello, <br />
<br />
I have sheets in excel 2007. <br />
1'st keeps vendor info like name, address, phone etc<br />
2'nd is PO form. <br />
I'd like have opportunity to pickup vendor name on PO form from drop down list (working right now) and other fields (address, phone, contact) should fill up automatically based on my selection. <br />
How can I do that ? What will be best solution ?
</div>
</div>


Hello, 

I have sheets in excel 2007. 
1'st keeps vendor info like name, address, phone etc
2'nd is PO form. 
I'd like have opportunity to pickup vendor name on PO form from drop down list (working right now) and other fields (address, phone, contact) should fill up automatically based on my selection. 
How can I do that ? What will be best solution ?

drop down menu in excel 2007 update multiple fiels on PO form

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.