ranges in individual worksheets to appear on a summary worksheet, how?

[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
(e-mail address removed)

 

[Dave Peterson]

I think you'll need to provide some more info.

You could always select the range and put =rangename in it to retrieve the value

Or =if(rangename="","",rangename)

but without more info, I'd be hesitant to make any guess.

 

[L. T. Portella]

Thank you Dave. Here is some more info


1 Summary Worksheet
2
3
4
5 From Worksheet 1
6 Total 33 67 66 67 100 (here I would like to see
these values which are range "tables"
7 see
Worksheet 1
8 From Worksheet 2
9 Total 64 110 132 22 33 (here I would like to see these
values which are range "chairs"
10 see
Worksheet 2
11
12
****************************************************************************
***
13
14
15
16
17 Worksheet 1
18 10 22 34 12 34
19 23 45 32 55 66
20
21 Total 33 67 66 67 100 lets call it range "tables"
22
23
****************************************************************************
**
24 Worksheet 2
25 32 55 66 10 22
26 32 55 66 12 11
27
28 Total 64 110 132 22 33 lets call it range "chairs"


An oversimplification of what I am trying to do is

1. Create a range in Worksheet 1 called "tables"
2. Create a range in Worksheet 2 called "chairs"
Now in a separate third worksheet named Summary I would like to see the
values
of ranges: "tables" followed by the values of range "chairs"

Thank you for your help

(e-mail address removed)

 

[Dave Peterson]

I'm not sure if this is what you want, but suppose your Chairs range is 10 rows
by 8 columns.

Select a range on that summary sheet that's 10x8.

Type =chairs
and hit control enter

Same kind of thing with tables (but put it right under the chairs formula).