Hi,

The following macro will find the value that you enter in a specific cell. I
have used cell F1 in the code but you can change that to any other cell not
in use but you will need to edit the macro accordingly. Each time you enter a
value in the cell, the row with the value will be selected (Highlighted)
which should make it easy to read the data.

After you paste the macro into your workbook, you will see some lines in
green. These are comment (information) lines and do not form part of the
code. You may need to do some simple editing of the code as per these
instructions.

To copy the macro into your workbook:-

Ensure that you have macros enabled with notification. (See options)

Right click on the worksheet name tab where you have your data. Then Select
View code which will open the VBA editor in the worksheet area.

Copy the macro below and then paste it into the large white area of the VBA
editor.

Alt/F11 will toggle between the VBA editor and the worksheet.

Edit the code if required so that the column with your codes is correct and
the cell where you want to enter the data is correct.

to close the VBA editor, Click on the X with the red background top right of
screen.

Type a code into the cell where you want to enter the data. If not found,
you will get a message accordingly otherwise the row will be highlighted.

As a tip: If you freeze the panes below the column headers and use a cell
within the frozen panes area for the value to find, you will never have to
scroll back to the row to enter a new value.

Feel free to get back to me if you have any problems or want some
alterations to the macro.

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.