Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Incorporation of Data Into Separate Document
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? |
#2
|
|||
|
|||
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 -- "LDWyatt" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting data from a pasted document | Excel Worksheet Functions | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Getting specific data from a word document into an excel sheet | Excel Worksheet Functions | |||
How do I plot data in Excel that is captured on separate sheets; . | Excel Discussion (Misc queries) |