Hi, I have a problem. I want to be able to supply multi cells with only filling in one single cell. like if i fill in an ID number it will fill in Name, Product amounts. For example
Worksheet 1
ID:
Name:
A............B............C
Product...Amount....Price
??..........???...........???
Worksheet 2
A......B.........C............D.............E
ID.....Name...Product...Amount....Price
112...Sony....TV..........200..........800.00
i would like to input the ID number in worksheet one and it auto put in the Name, Product, amount, and price from worksheet 2.
On the second worksheet all the info is on a single row.
i was hoping there was a way to link column with cells and fill in based on using one of them cells in a row.
Worksheet 1
ID:
Name:
A............B............C
Product...Amount....Price
??..........???...........???
Worksheet 2
A......B.........C............D.............E
ID.....Name...Product...Amount....Price
112...Sony....TV..........200..........800.00
i would like to input the ID number in worksheet one and it auto put in the Name, Product, amount, and price from worksheet 2.
On the second worksheet all the info is on a single row.
i was hoping there was a way to link column with cells and fill in based on using one of them cells in a row.