Autofill from another excell worksheet

[dmyrhaug]

Hi

I have created a dictionary that I would like to use to autofill another worksheet. For example, if I type in code 123456 in the target worksheet, it should autofill several cells with the information from the dictionary. Is there an easy way to do this?

Thank you for your help!

[oeldere]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.