Excel VBA

[Quickard]

Hello,

I Don't know where to really start so here goes.

I have a list of parts on one sheet that includes the following (sheet name is: Products):
Part Number, Part Description, Part Price.

On another sheet I have a job (sheet name: Job) that has different parts depending on the job, on this sheet I currently hand enter the part number, part description, part price and quantity, there are hundreds of different parts I have to enter, so currently I copy and paste them. I would like to just type part numbers into the job sheet, highlight them (only certain ones) and then hit a button that would bring the product description and price into the other columns.

I know its a tall order but I would like to learn VBA and would really appreciate any help.

 

[Ziggy12]

Instead of hitting a button you could try a vlookup. which will return the data your after based on the part number with a flag to return the part product description and price into the other columns.

=e.g. if (b2="Yes",VLOOKUP(A2,Products!$A$1:$D$33,2,FALSE),"Leave Blank")


cheers
ziggy