List consolidation

Hi all,

I am trying to create a macro that copies a list of products from sheet 1 (Master product list), copies the cost of each product from sheet 2 (input sheet) and pastes them to an existing list of products on sheet 3 (Output sheet).

The list on sheet 3 is an expanding list and needs to only copy and paste products with costs against them. Here is a picture below to illustrate. The button on the second sheet needs to run the macro

Picture1.jpg


Any help with this much appreciated.

Thanks in advance.

Perfect, Thanks!