ranges to appear in a summary worksheet

[L. T. Portella]

I have one workbook with a summary worksheet and at least 50 more individual
worksheets. Each one of these individual worksheets have many named ranges
and I want some of them to appear on the first summary worksheet. How can I
do that? Thank you

 

[Otto Moehrbach]

L.T.
I would use a macro for that. If you know your way around macros, make
the Summary sheet the active sheet and use a number of statements like this
one:
Range("RangeName1").Copy [A1]
RangeName1 is one of the range names you have in one of the other sheets.
The A1 is the cell address of the top left corner of where you want that
particular data pasted in the Summary sheet. Note that there has to be a
space after the word "Copy". Also note that no reference to the source
sheet is required.
Repeat the above statement for each of the other named ranges
(RangeName2, etc) and its destination.
If you need some help setting this up, send me a small file with just a
few sheets to demonstrate what you have and include where you want each
named range pasted in the Summary sheet. I'll setup the macro for you and
then you can add lines to include all the other named ranges.
Also include something about when/how you want this macro to execute.
For instance, at file opening? Or file closing? Or when you click on a
button? Or when you enter something in some cell of the Summary sheet? Or
whatever?
Also include any pattern that exists in the range names that Excel might
be able to use in a looping macro.
Include the version of Excel you are using.
Remove "hello" from my address or it will go nowhere. HTH Otto

 

[immanuel]

Given a defined name, "Range1", that's points to range of 3x5 cells, select
a 3x5 range of cells on the first summary page and enter:

=Range1

in the first cell of the range and hit Ctrl-Shift-Enter.

Is that what you wanted?

/i.