I can't see OssieMac's code either but unless I am reading you wrong you
don't need VBA.
In B2 enter:
=IF($A$2="","",VLOOKUP($A2,$A3:$E10000,COLUMNS($A$ 2:B2),FALSE))
and drag across to E2 using the fill handle.
If your data is wider than Column E then expand that range in the formula.
Now hen you enter a Product Code in A2 the other cells will automatucall
fill in with the other data.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"BB" wrote in message
...
Hello
I have a spreadsheet of a rather large stocklist. I use this to check off
the price charged on the invoice when we receive the goods, against the
quoted buy price in the spreadsheet. Column A3 - A8000 (ish) contains a
product code; B3 = description; C3 = buy price; D3 = sell price; E3 =
Profit
margin, etc.
What I would like to do to make this job of checking the prices off more
efficient, is to type in the product code of the item i am checking in
say,
A2, and have the corresponding information appear. Is this possible???
Any help would be greatly appreciated. Thank you