How to start?

[bkpiko]

Hello

I have no clue what to do or how to start. I have excel 2007. I watched some youtube examples and still couldn't figure out how to do this. I have this on worksheet 1. On another worksheet 2 I would like to make a list of members in alphabet order for the month of January, That I checked off from worksheet 1 with an X. Thank You for your Help.

Example

January Feb. March

doe john X

doe jane X

smith john X X X

 

[Smitty]

Welcome to the Board!

Do you just want a straight list of names? I.E. would "smith john" be listed in three consecutive rows, or does it need to follow the format from sheet1?

You can probably do what you want with a change event, but you'll have to give more details. If you follow the link beneath my sig you can post shots of sheet1 & 2.

 

[bkpiko]

Sorry Smitty you're dealing with a computer dummy. So how do I send you a copy of the workbook.

 

[Smitty]

Follow the link beneath my sig:

Mr Excel HTML Maker - Post a shot of your sheet

That will take you to a public SkyDrive folder where we have the Board's HTML Maker. It's an add-in that will let you post a shot of your sheet. There's also a user's guide there.

 

[bkpiko]

Does HTML Maker work with Window 7 and Excel 2007? The only thing that happens is there is add-ins on the page, but when I click on it there is a Mrexcel Html on the left. Clicking MrExcel Html it gives three choices Generate Html (set default) and so on. There is nothing else. Is some else I have to do or Can I just e-mail you the workbook? Thanks for your time.

 

[Smitty]

Highlight your range and select the first option, then come back here and use CTRL+V to paste the code. When you post, the code will render.

The HTML Maker won't give you any notice that it's done anything, it just does it.

 

[bkpiko]

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Players</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Handicap Index #</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">January 2011</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">February 2011</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">March 2011</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">April 2011</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">May 2011</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="border-top: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Asato, John</td><td style=";">13.9</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";"></td><td style=";"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">Asuncion, Randy</td><td style=";">24.9</td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";"></td><td style=";"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">Cardinez, Larry</td><td style=";">17.0</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style=";"></td><td style=";"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style=";">Choi, Dede</td><td style=";">28.8</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style=";"></td><td style=";"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style=";">De Castro, Donald J</td><td style=";">23.1</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style=";"></td><td style=";"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style=";">Dineros, Dino S  </td><td style=";">24.0</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style=";"></td><td style=";"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style=";">Fujimoto, Sam</td><td style=";">37.2</td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style=";"></td><td style=";"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style=";">Goya, Andy</td><td style=";">20.0</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style=";"></td><td style=";"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style=";">Goya, Lynda</td><td style=";">21.2</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style=";"></td><td style=";"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style=";">Hamada, Jerry</td><td style=";">15.2</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style=";"></td><td style=";"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style=";">Hamada, Lenni</td><td style=";">26.3</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />
<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">January 2011</td><td style=";">Handicap Index #</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet2</p><br /><br />

Thank You

 

[bkpiko]

Sorry what I would to like to have, is the participating players for the month of January on Sheet 2 after I check them off with an X on sheet 1. In Alphabet order.

 

[Smitty]

OK, you can use Advanced Filter-->Copy to another location-->Unique Records only to create your list of players, paste it somehwere on the first sheet, then cut it to the summary sheet (advanced filter will only copy a range on the active sheet).

Then you can use INDEX/MATCH to line everything up:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="color: #0000FF;background-color: #FFFF00;;">Players </td><td style="color: #0000FF;background-color: #FFFF00;;">Handicap Index # </td><td style="text-align: center;color: #0000FF;background-color: #FFFF00;;">January 2011</td><td style="text-align: center;color: #0000FF;background-color: #FFFF00;;">February 2011</td><td style="text-align: center;color: #0000FF;background-color: #FFFF00;;">March 2011</td><td style="text-align: center;color: #0000FF;background-color: #FFFF00;;">April 2011</td><td style="text-align: center;color: #0000FF;background-color: #FFFF00;;">May 2011</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Asato, John</td><td style="text-align: right;;">13.9</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Asuncion, Randy </td><td style="text-align: right;;">24.9</td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">Cardinez, Larry</td><td style="text-align: right;;">17</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B2</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A2,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">B$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C2</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A2,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">C$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D2</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A2,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">D$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E2</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A2,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">E$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F2</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A2,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">F$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G2</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A2,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">G$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B3</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A3,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">B$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C3</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A3,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">C$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D3</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A3,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">D$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E3</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A3,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">E$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F3</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A3,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">F$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G3</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A3,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">G$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B4</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A4,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">B$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C4</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A4,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">C$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D4</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A4,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">D$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E4</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A4,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">E$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F4</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A4,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">F$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G4</th><td style="text-align:left">=INDEX(<font color="Blue">Sheet1!$B$2:$G$23,MATCH(<font color="Red">$A4,Sheet1!$A$2:$A$26,0</font>),MATCH(<font color="Red">G$1,Sheet1!$B$1:$G$1,0</font>)</font>)</td></tr></tbody></table></td></tr></table><br />

HTH,