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>
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>