Advanced Filter Macro Needed

[Excel_Assis]

Hi all can any one help with an Advanced Filter macro to produce a summary of the below data on sheet1. The sample summary result is shown further down.

The summary list needs to be a combination of UNIQUE job numbers from the two combined Job No. columns.

The only columns I need in the summary from the data list are columns ITEM (merged B,C,D), Acc Code (E), Job No A (I) and Job No B (K).

So the macro needs to ignore the columns in between and blank cells and rows.

The macro also needs to clear the summary area before inserting the new summary data.

Sheet1


<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: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 68px"><COL style="WIDTH: 67px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></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>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">DATE</TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold" colSpan=3>ITEM</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">ACC CODE</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">US$</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">RECEIPT</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">JOB NO. A</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">JOB A US$</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">JOB NO. B</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">JOB B US$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 10pt" colSpan=3>Cat</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10005</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$5.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$5.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">Yes</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$2.50</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">9876</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">$2.50</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 10pt" colSpan=3>Dog</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$87.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$87.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">No</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$87.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 10pt" colSpan=3>Rat</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10006</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$23.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$23.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">No</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$23.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 10pt" colSpan=3>Pig</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10008</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$56.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$56.00</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$56.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 10pt" colSpan=3>Rat</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10006</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$4.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$4.00</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$4.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 10pt" colSpan=3>Dog</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$6.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$6.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">Yes</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">9876</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">$6.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 10pt" colSpan=3>Dog</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$98.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$98.00</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$98.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 10pt" colSpan=3>Pig</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10008</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$23.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$23.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">No</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">9876</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">$23.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 10pt" colSpan=3>Cat</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10005</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$21.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$21.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">Yes</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$21.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 10pt" colSpan=3>Dog</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$65.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$65.00</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">6789</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$65.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt" colSpan=3></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$0.00</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><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></TR><TR style="HEIGHT: 18px"><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></TR></TBODY></TABLE>


Required result

Sheet2

<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: 103px"><COL style="WIDTH: 69px"><COL style="WIDTH: 70px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-WEIGHT: bold" rowSpan=2>Date Entered</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-WEIGHT: bold" rowSpan=2 colSpan=4>ITEM</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-WEIGHT: bold" rowSpan=2>Acc No.</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-WEIGHT: bold" rowSpan=2>Job No.</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center" colSpan=4>2</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center">4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD> </TD><TD style="TEXT-ALIGN: left" colSpan=4>Cat</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10005</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">1234</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD> </TD><TD style="TEXT-ALIGN: left" colSpan=4>Cat</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10005</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">9876</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD> </TD><TD style="TEXT-ALIGN: left" colSpan=4>Dog</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">1234</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD> </TD><TD style="TEXT-ALIGN: left" colSpan=4>Dog</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">9876</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD> </TD><TD style="TEXT-ALIGN: left" colSpan=4>Dog</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">6789</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD> </TD><TD style="TEXT-ALIGN: left" colSpan=4>Pig</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10008</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">1234</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD> </TD><TD style="TEXT-ALIGN: left" colSpan=4>Pig</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10008</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">9876</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD> </TD><TD style="TEXT-ALIGN: left" colSpan=4>Rat</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10006</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">1234</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD> </TD><TD colSpan=4> </TD><TD style="BACKGROUND-COLOR: #ccccff"> </TD><TD style="BACKGROUND-COLOR: #c0c0c0"> </TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[Datsmart]

Advanced Filter requires a couple of things that you don't mention/show in your data.

1. Advanced Filter requires a Criteria Range
There you will input the requirements and columns you want to filter.

2. Your target range, shown as "Sheet2" in your example, must contain the Column Headers you want to include and they must match columns Headers in the original data. Your example uses Header names not listed your your original data.

Good example of Advanced Filter steps here:
http://www.contextures.com/xladvfilter01.html

AdvancedFilter Video Demo here:
http://www.contextures.com/xlVideos04.html
http://www.contextures.com/xlVideos04.html#AdvFilt2007