Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Linking and Formatting across worksheets to form Summary Page - Only pull/link non-null fields | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |