Incorporation of Data Into Separate Document

L

LDWyatt

I have 3 columns of data in Excel: Vendor Name, Vendor ID and Cost Code. In
a separate document/form, I want to type the first word in the Vendor Name
and have the entire Vendor Name, Vendor ID and Cost Code for that vendor
automatically populate specific locations on the form. Seems simple enough,
but I can't figure it out. Can anyone help?
 
J

Jason Marshall

Autopopulation in Excel can only take effect after the field has already
been entered once.

Unless, you are talking a IF Formula.

If cell A1 = <A> then Vendor ID = <V ID> and <Cost Code>

That is possible with standard IF formula's.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

correlating and summing data from multiple spreadsheets 1
Display Search Results in Form 1
Data entry form 2
Subform causing duplicate records? 7
Macro Question 2
how to requery on new record continuous form 1
Consolidation Table from Different Excel Tabs with Different Format 1
Basic file, data only once to summary? 2

Top