copy & paste entire sections with a button

[Nikki]

Hi,

Is there a way to take an entire formatted section of excel (grouped and
coloured etc) and paste it below with the click of a button?

Regards

 

[Bob Greenblatt]

Hi,

Is there a way to take an entire formatted section of excel (grouped and
coloured etc) and paste it below with the click of a button?

Regards

You could use the camera tool to 'take a picture" of the area and paste it
where ever you want. The picture is "live" in that it will change when the
original cells change, but you will not otherwise be able to change the
image.

 

[CyberTaz]

Not with "a single button" - but select/copy/paste can't be all that much
trouble