It's hard to explain. I want to be able to link two sheets. One being a data sheet with a code to represent each group of data then I want to be able to enter the code on another worksheet and have the adjacent cells update with data from the data sheet. Does that make sense ??

E.g
Code. From. To. Km
1. Sydney. Melbourne. 1000
2. Brisbane. Perth. 2000


I want to be able to enter the number 1 on a spreadsheet say in a1 then have cells a2. A3. And a4. Populate with data from the data sheet.

So it'd look like
A1. A2. A3. A4
1. Sydney. Melbourne. 1000

All I had to type is 1 and cells a2 a3 and a4 populate automatically..

Please help or ask questions if you don't understand.


Thanks!!!