Hi everyone,

I would like to do what I think would be a simple thing for you VBA geniuses but very difficult for me to say the least.

I have attached a very basic example to capture what I'm trying to achieve. I have a massive workbook on which I track inventory via figures and graphs (on separate spreadsheets). My aim is to have a macro (that I'd link to a shape) to copy the highlighted sections in yellow as well as the graph from the other spreadsheet on a new workbook. The layout needs to be slightly different as it will be sent to different users who shouldn't have access to all the info available in the original workbook.

I would like all the values to be copied as "values only" and the graph as a bitmap. Also, there will probably be conditional formatting in columns B, C, D, G and H mainly dependent on how small or high the figures are. In a perfect world, I would also like to copy this formatting across.

The end result (which would need to be on a different workbook) is on the spreadsheet called "Target Layout", including the frozen pans and background colors.

I've managed to do something very dodgy with the macro recorder so I would assume it could work but I definitely some help.

Anyone's help on this would be massively appreciated :-D

Sub

Example inventory.xlsx