amend vba code to copy as values

thank you for your quick response and time. the code you gave works but are you able to make it so that it still includes formats and pictures :-))

thank you works perfectly :-)

I'm taking apart the copy / paste to copying the images and the data grid. I commented out the lines you can delete

Please Login or Register  to view this content.

I have come across an error I can't resolve - any help appreciated. If I formulate the data tab it sometimes does not copy / paste values correctly. The information seems to get jumbled

If you test the 'Dashboard test' file - In the data tab section 2 cell G35 I have formulated to pick up cell G23, In the display sheet when you select 'Section 2' for that formulated cell it seems to be looking at cell G3 which is blank and pasting blank instead of paste values of cell G35?

Hopefully someone can review the code and check the error? :-) Thanks

did not realise dflak already solved this. thread solved :-)

thanks again!