Merging two reports with some data matching

[Mark F]

Hi All

I have two separate reports/ workbooks which I need to Merge together.

In column A in the SALES report are barcode numbers , column B description with other columns having Sales and profit details.

The STOCK report details all the products that are in stock now, with column A again having the barcode numbers, column B description , the next having stock levels and items costs

There may also be the situation where a product in the STOCK report is new stock and so has not sold previously so the barcode number will not appear in the first report.

I want to produce a report with the barcodes on the left , with the sales and profit details from the first report and the stock levels / item costs from the second report as applicable

The reports are currently in separate workbooks but can be put into one.

Could anyone suggest the best way for me to do what I want to do whether via VBA or formula

Thanks in advance

Mark

 

[santeria]

This might have some useful info:


http://www.mrexcel.com/board2/viewtopic.php?t=71281&highlight=merging+sheets

 

[Mark F]

Thanks for the idea, but not quite what I need.

I have a worksheet which has the product and sales info.

I have a sheet which has similar product details (but not exactly the same) and has profit details

I need to produce a report with the product details, sales and profit on the same sheet.

The product details are in the same columns in each sheet,

Any ideas?

Mark