hi
i have a code for each row of data in one sheet , but i dont know how to, when i go on to a different sheet, link it up so that when i type in that code that row that it corrisponds to will be copied and pasted to where i want it to be.

Just a thought, but have you looked at VLOOKUP in the help file?

Smitty

yes thanx but i still wouldnt know wot i would be writing in. i will add the attatchment so you see wot i mean

See the VLOOKUPS that I added.

Smitty

thanx but this isnt what i quite wanted. i wanted to type the code in the table and the description, size, price, and qty would appear

That's what happens with what I posted.

Try deleting the code and see what happens. Then type the code back in.

If you want to get around the #N/A error message, adjust the formulas as so:

=IF(ISNA(VLOOKUP(Lookup Range, Source Range, Column Index, FALSE)),"",VLOOKUP(Lookup Range, Source Range, Column Index, FALSE))

Smitty

this is it

Here you go.

Note comments in Blue.

Smitty