Linking to Summary Tab
 

I have a summary tab that is lad out as follows:
Column A Column B
1101
1102
1103

I have individual tabs named 1101, 1102, 1103, etc... This is one field in
each tab (same cell reference D20) that I want to link in the summary. I
know I can click on each tab and do a simple link =+'1001'!D20 - but wanted
another way - more effecient way using a formula in the summary tab- a look
up of sorts. Any ideas??

Linking to Summary Tab
 

You can use indirect

=INDIRECT(A1&"!$D$20")

And copy down


--

Regards Ron de Bruin
http://www.rondebruin.nl



"JS" wrote in message
...
I have a summary tab that is lad out as follows:
Column A Column B
1101
1102
1103

I have individual tabs named 1101, 1102, 1103, etc... This is one field in
each tab (same cell reference D20) that I want to link in the summary. I
know I can click on each tab and do a simple link =+'1001'!D20 - but
wanted
another way - more effecient way using a formula in the summary tab- a
look
up of sorts. Any ideas??

Linking to Summary Tab
 

Ron will want you to use:

=indirect("'" & a1 & "'!$d$20")
or
=indirect("'" & a1 & "'!d20")

(the $ signs aren't important when they're in =indirect(), but the apostrophes
will be important.)

Ron de Bruin wrote:

You can use indirect

=INDIRECT(A1&"!$D$20")

And copy down

--

Regards Ron de Bruin
http://www.rondebruin.nl

"JS" wrote in message
...
I have a summary tab that is lad out as follows:
Column A Column B
1101
1102
1103

I have individual tabs named 1101, 1102, 1103, etc... This is one field in
each tab (same cell reference D20) that I want to link in the summary. I
know I can click on each tab and do a simple link =+'1001'!D20 - but
wanted
another way - more effecient way using a formula in the summary tab- a
look
up of sorts. Any ideas??

--

Dave Peterson

Linking to Summary Tab
 

Thanks for the correction Dave

Never use a sheet name with a space in it <g

--

Regards Ron de Bruin
http://www.rondebruin.nl



"Dave Peterson" wrote in message
...
Ron will want you to use:

=indirect("'" & a1 & "'!$d$20")
or
=indirect("'" & a1 & "'!d20")

(the $ signs aren't important when they're in =indirect(), but the
apostrophes
will be important.)

Ron de Bruin wrote:

You can use indirect

=INDIRECT(A1&"!$D$20")

And copy down

--

Regards Ron de Bruin
http://www.rondebruin.nl

"JS" wrote in message
...
I have a summary tab that is lad out as follows:
Column A Column B
1101
1102
1103

I have individual tabs named 1101, 1102, 1103, etc... This is one field
in
each tab (same cell reference D20) that I want to link in the summary.
I
know I can click on each tab and do a simple link =+'1001'!D20 - but
wanted
another way - more effecient way using a formula in the summary tab- a
look
up of sorts. Any ideas??

--

Dave Peterson

Linking to Summary Tab
 

Or all numbers <bg.

Ron de Bruin wrote:

Thanks for the correction Dave

Never use a sheet name with a space in it <g

--

Regards Ron de Bruin
http://www.rondebruin.nl

"Dave Peterson" wrote in message
...
Ron will want you to use:

=indirect("'" & a1 & "'!$d$20")
or
=indirect("'" & a1 & "'!d20")

(the $ signs aren't important when they're in =indirect(), but the
apostrophes
will be important.)

Ron de Bruin wrote:

You can use indirect

=INDIRECT(A1&"!$D$20")

And copy down

--

Regards Ron de Bruin
http://www.rondebruin.nl

"JS" wrote in message
...
I have a summary tab that is lad out as follows:
Column A Column B
1101
1102
1103

I have individual tabs named 1101, 1102, 1103, etc... This is one field
in
each tab (same cell reference D20) that I want to link in the summary.
I
know I can click on each tab and do a simple link =+'1001'!D20 - but
wanted
another way - more effecient way using a formula in the summary tab- a
look
up of sorts. Any ideas??

--

Dave Peterson

--

Dave Peterson

Linking to Summary Tab
 

Yes, I love this macro to do it for me
http://www.rondebruin.nl/summary.htm

All those'''''''''''''''''''''''''''''''''''''''' confuse me



--

Regards Ron de Bruin
http://www.rondebruin.nl



"Dave Peterson" wrote in message
...
Or all numbers <bg.

Ron de Bruin wrote:

Thanks for the correction Dave

Never use a sheet name with a space in it <g

--

Regards Ron de Bruin
http://www.rondebruin.nl

"Dave Peterson" wrote in message
...
Ron will want you to use:

=indirect("'" & a1 & "'!$d$20")
or
=indirect("'" & a1 & "'!d20")

(the $ signs aren't important when they're in =indirect(), but the
apostrophes
will be important.)

Ron de Bruin wrote:

You can use indirect

=INDIRECT(A1&"!$D$20")

And copy down

--

Regards Ron de Bruin
http://www.rondebruin.nl

"JS" wrote in message
...
I have a summary tab that is lad out as follows:
Column A Column B
1101
1102
1103

I have individual tabs named 1101, 1102, 1103, etc... This is one
field
in
each tab (same cell reference D20) that I want to link in the
summary.
I
know I can click on each tab and do a simple link =+'1001'!D20 -
but
wanted
another way - more effecient way using a formula in the summary tab-
a
look
up of sorts. Any ideas??

--

Dave Peterson

--

Dave Peterson