Match worksheet problem

ScreaminPain

Board Regular
Joined
Feb 8, 2009
Messages
58
Hello Board...

I need to import data into master sheet from another sheet in the same workbook. The imported data is is located in the same row and cell number on all sheets in the workbook.

I need to MATCH a cell on the master with a SHEET name and then import the correct data for that match. I imagine, it boils down to how to match a worksheet rather than a table within a sheet.

I hope the image below is veiwable. The master sheet contains everything from column A:R. A different sheet labeled SFO contains the data from S:Y. I want to place the data from S3:Y13 (found on a different sheet) beginning at cell D8. Cell A4 is the reference and that cell changes daily, so I need to match A4 with any of 30 sheets and then import the data. Hopefully, I made myself clear. Any assistance is greatly appreciated.....

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 44px"><COL style="WIDTH: 152px"><COL style="WIDTH: 32px"><COL style="WIDTH: 34px"><COL style="WIDTH: 30px"><COL style="WIDTH: 31px"><COL style="WIDTH: 29px"><COL style="WIDTH: 32px"><COL style="WIDTH: 32px"><COL style="WIDTH: 29px"><COL style="WIDTH: 34px"><COL style="WIDTH: 32px"><COL style="WIDTH: 29px"><COL style="WIDTH: 28px"><COL style="WIDTH: 32px"><COL style="WIDTH: 28px"><COL style="WIDTH: 12px"><COL style="WIDTH: 50px"><COL style="WIDTH: 58px"><COL style="WIDTH: 43px"><COL style="WIDTH: 131px"><COL style="WIDTH: 147px"><COL style="WIDTH: 61px"><COL style="WIDTH: 68px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD><TD>P</TD><TD>Q</TD><TD>R</TD><TD>S</TD><TD>T</TD><TD>U</TD><TD>V</TD><TD>W</TD><TD>X</TD><TD>Y</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt">overall</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt">H/A</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt" colSpan=7>Last 3 gm's</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt">BP</TD><TD></TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #666699; FONT-FAMILY: Cambria; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">SAN FRANCISCO GIANTS</TD><TD style="BACKGROUND-COLOR: #666699; COLOR: #ffffff"></TD><TD style="BACKGROUND-COLOR: #4f81bd"></TD><TD style="BACKGROUND-COLOR: #666699"></TD><TD style="BACKGROUND-COLOR: #ccccff; FONT-SIZE: 9pt">LAST 10 GMS.</TD><TD style="BACKGROUND-COLOR: #ccccff; FONT-SIZE: 9pt">odds</TD><TD style="BACKGROUND-COLOR: #ccccff; FONT-SIZE: 9pt">o/u</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD></TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Cambria">Team Pitching</TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">ERA</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Whip</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">baa</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">rank</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Whip</TD><TD style="BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">ERA</TD><TD style="BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Whip</TD><TD style="BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">baa</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">IP</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Rn's</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">TB's</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">BB</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">ERA</TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">5/1</TD><TD style="FONT-SIZE: 9pt">SF</TD><TD style="FONT-SIZE: 9pt">W 5-2</TD><TD style="FONT-SIZE: 9pt">Matt Cain (R)</TD><TD style="FONT-SIZE: 9pt">Jordan Zimmermann (R)</TD><TD style="FONT-SIZE: 9pt">W 114</TD><TD style="FONT-SIZE: 9pt">O 6.5 -107</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-WEIGHT: bold">SFO</TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 9pt; FONT-WEIGHT: bold">M BUMGARNER</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">(L)</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">6.17</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">1.76</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccccff; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">0.323</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">147</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">1.47</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">4.71</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">1.37</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">#N/A</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 8pt">4.34</TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/30</TD><TD style="FONT-SIZE: 9pt">SF</TD><TD style="FONT-SIZE: 9pt">L 1-2</TD><TD style="FONT-SIZE: 9pt">Jonathan Sanchez (L)</TD><TD style="FONT-SIZE: 9pt">John Lannan (L)</TD><TD style="FONT-SIZE: 9pt">L 115</TD><TD style="FONT-SIZE: 9pt">U 7.5 -104</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-WEIGHT: bold">WAS</TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 9pt; FONT-WEIGHT: bold">T GORZELANNY</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">(L)</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">3.97</TD><TD style="BACKGROUND-COLOR: #ffffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">#N/A</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccccff; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">0.195</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">1.05</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">2.60</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">1.10</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">#N/A</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 8pt">3.48</TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/29</TD><TD style="FONT-SIZE: 9pt">SF</TD><TD style="FONT-SIZE: 9pt">W 3-0</TD><TD style="FONT-SIZE: 9pt">Tim Lincecum (R)</TD><TD style="FONT-SIZE: 9pt">Jason Marquis (R)</TD><TD style="FONT-SIZE: 9pt">W 146</TD><TD style="FONT-SIZE: 9pt">U 6.5 110</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/28</TD><TD style="FONT-SIZE: 9pt">NYM</TD><TD style="FONT-SIZE: 9pt">W 4-3</TD><TD style="FONT-SIZE: 9pt">Chris Capuano (L)</TD><TD style="FONT-SIZE: 9pt">Livan Hernandez (R)</TD><TD style="FONT-SIZE: 9pt">W 102</TD><TD style="FONT-SIZE: 9pt">U 8 -106</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center">Gm #</TD><TD>Team</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/27</TD><TD style="FONT-SIZE: 9pt">NYM</TD><TD style="FONT-SIZE: 9pt">L 3-6</TD><TD style="FONT-SIZE: 9pt">R.A. Dickey (R)</TD><TD style="FONT-SIZE: 9pt">Tom Gorzelanny (L)</TD><TD style="FONT-SIZE: 9pt">L -103</TD><TD style="FONT-SIZE: 9pt">O 8.5 -117</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">901</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 9pt; FONT-WEIGHT: bold">SAN FRANCISCO GIANTS</TD><TD></TD><TD style="TEXT-ALIGN: center">x</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/26</TD><TD style="FONT-SIZE: 9pt">NYM</TD><TD style="FONT-SIZE: 9pt">L 4-6</TD><TD style="FONT-SIZE: 9pt">Chris Young (R)</TD><TD style="FONT-SIZE: 9pt">Jordan Zimmermann (R)</TD><TD style="FONT-SIZE: 9pt">L -110</TD><TD style="FONT-SIZE: 9pt">O 7.5 -108</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">902</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 9pt; FONT-WEIGHT: bold">WASHINGTON NATIONALS</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/25</TD><TD style="FONT-SIZE: 9pt">@ PIT</TD><TD style="FONT-SIZE: 9pt">L 2-4</TD><TD style="FONT-SIZE: 9pt">John Lannan (L)</TD><TD style="FONT-SIZE: 9pt">Paul Maholm (L)</TD><TD style="FONT-SIZE: 9pt">L 120</TD><TD style="FONT-SIZE: 9pt">U 8 -110</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/24</TD><TD style="FONT-SIZE: 9pt">@ PIT</TD><TD style="FONT-SIZE: 9pt">W 6-3</TD><TD style="FONT-SIZE: 9pt">Jason Marquis (R)</TD><TD style="FONT-SIZE: 9pt">Kevin Correia (R)</TD><TD style="FONT-SIZE: 9pt">W 120</TD><TD style="FONT-SIZE: 9pt">O 8 -107</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/23</TD><TD style="FONT-SIZE: 9pt">@ PIT</TD><TD style="FONT-SIZE: 9pt">L 2-7</TD><TD style="FONT-SIZE: 9pt">Livan Hernandez (R)</TD><TD style="FONT-SIZE: 9pt">Jeff Karstens (R)</TD><TD style="FONT-SIZE: 9pt">L 110</TD><TD style="FONT-SIZE: 9pt">O 8.5 -113</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/21</TD><TD style="FONT-SIZE: 9pt">@ STL</TD><TD style="FONT-SIZE: 9pt">L 0-5</TD><TD style="FONT-SIZE: 9pt">Tom Gorzelanny (L)</TD><TD style="FONT-SIZE: 9pt">Kyle Lohse (R)</TD><TD style="FONT-SIZE: 9pt">L 145</TD><TD style="FONT-SIZE: 9pt">U 8 -104</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/20</TD><TD style="FONT-SIZE: 9pt">@ STL</TD><TD style="FONT-SIZE: 9pt">L 3-5</TD><TD style="FONT-SIZE: 9pt">Jordan Zimmermann (R)</TD><TD style="FONT-SIZE: 9pt">Jaime Garcia (L)</TD><TD style="FONT-SIZE: 9pt">L 149</TD><TD style="FONT-SIZE: 9pt">O 7.5 103</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
You're going to have to use INDIRECT.
For example, you'll enter something like =INDIRECT($A$4 & "!" & ADDRESS(ROW()-5, COLUMN()+14))

I used the "-5" and "+14" to match the coordinates as they appear on your sample spreadsheet. You'll have to adjust them to match their actual positions.
 
Upvote 0
You're going to have to use INDIRECT.
For example, you'll enter something like =INDIRECT($A$4 & "!" & ADDRESS(ROW()-5, COLUMN()+14))

I used the "-5" and "+14" to match the coordinates as they appear on your sample spreadsheet. You'll have to adjust them to match their actual positions.

Yes, it seems as if this should work, but I can't write code and I'm not familiar with the INDIRECT function. I'm not getting the syntax correct.

My imported data is found beginning on column 1 row 55.....the same location on each sheet. My 30 sheets are from ATL:WAS. Using this information can you show me the exact code for placing the data in D8 of my example?

Once again thanks for your attention....
 
Upvote 0
You'll enter: =INDIRECT(ADDRESS(ROW()+47, COLUMN()-3,,,$A$4))
Remember, you're going to have to format the section you enter the formulas in. The dates, for example, are going to appear as numbers, until you format them as dates.

As a bit of friendly advice. It's worth learning a little about what's happening, so that you'll be able to make your own adjustments as needed. Right now, your problem is solved, but if you have no idea what's going on, then the second anything changes on your spreadsheet, you'll be in trouble. It would be worthwhile to get a beginner's Excel book to learn what's going on, from the ground up.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top