Array-copy a range; how to duplicate format of source?

L

L Mehl

Hello --

I want to create a "summary" worksheet in a large workbook, which will
repeat portions of the individual Marketing, Engineering, and Finance
("source") worksheets.

I define ranges in each of the source worksheets, and Ctrl-Shift-Enter each
range name in different areas of the summary worksheet.
The format of the source area is not repeated in the summary area, so I
return to the source, highlight the area, Copy, and then Paste Special >
Format in the summary area.

Is there a way to copy the range and its format at the same time?

Thanks for any help.

Larry Mehl
 
J

Jim Rech

Is there a way to copy the range and its format at the same time?

I don't think so.

I might get to the same place as you in a slightly different way though..

-Copy the source range (no need to name it unless to want to).
-Select the top left cell of the destination range.
-Do an Edit, Paste Special, and click the Paste Link button.
-Do Edit, Paste Special again, click Formats and OK.
-Press ESC to exit copy mode.

This doesn't result in an array formula but it does will over all the
results just like an array formula. And it's easier to work with because
you don't get the annoying "can't alter part of an array" message.
 
L

L Mehl

Thanks Jim.

Larry


Jim Rech said:
I don't think so.

I might get to the same place as you in a slightly different way though..

-Copy the source range (no need to name it unless to want to).
-Select the top left cell of the destination range.
-Do an Edit, Paste Special, and click the Paste Link button.
-Do Edit, Paste Special again, click Formats and OK.
-Press ESC to exit copy mode.

This doesn't result in an array formula but it does will over all the
results just like an array formula. And it's easier to work with because
you don't get the annoying "can't alter part of an array" message.
Click to expand...
 
Top