Copy Rectangle Object From One Sheet To Another
 

I am accumulating various bar charts (constructed from Excel rectangles) into
a single report. Is there a way to collect each "bar" (all the data cells
plus the appropriately-sized rectangles) into their respective places on my
Summary report? (I know how to get the cell data copied, but am not familiar
with retrieving objects and making sure they are the right size and in the
right place.

Thank you.
George