...still no response yet...

L

lincolnho

Board Regular
Joined
May 12, 2011
Messages
63
Hello, I'd like to extract rows based on dates from another sheet (which is also an extraction. What kind of formula is best and what formula works? I've been trying to get this answer for a week now.

<TABLE style="WIDTH: 568pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=756 border=0><COLGROUP><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4461" width=122><COL style="WIDTH: 101pt; mso-width-source: userset; mso-width-alt: 4937" width=135><COL style="WIDTH: 102pt; mso-width-source: userset; mso-width-alt: 4973" width=136><COL style="WIDTH: 113pt; mso-width-source: userset; mso-width-alt: 5485" width=150><COL style="WIDTH: 110pt; mso-width-source: userset; mso-width-alt: 5339" width=146><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" width=67><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 92pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #a6a6a6" width=122 height=17>Start Date</TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 101pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #a6a6a6" width=135>End Date</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 102pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=136></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 113pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=150></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 110pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=146></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 50pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=67></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17> (A2) 15-Jan-11</TD><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right> (B2) 10-Feb-11</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan" colSpan=2 height=17>Dynamic data from sheet2:</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #a6a6a6" height=17>(A5) Ops Manager</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #a6a6a6">Manager</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #a6a6a6">Agent</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #a6a6a6">Topic</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #a6a6a6">Action</TD><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #a6a6a6">Date</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Joshua Chasez</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Robert Van Winckle</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Mark Tewksbury </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Letter 1</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>27-Jan-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Joshua Chasez</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Mark Vincent </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Kevin Martin</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>11-Jan-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Virginia Hensley </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Joanna Levesque </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">John Morris</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>27-Jan-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Joshua Chasez</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Anna Bullock</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Marc Kennedy</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>3-Feb-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Beyonce Knowles</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Cherilyn La Pierre </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Ben Hebert</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>16-Feb-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Beyonce Knowles</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Eileen Edwards </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Tessa Virtue</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>9-Feb-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Beyonce Knowles</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Eileen Edwards </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Tessa Virtue</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>10-Feb-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Beyonce Knowles</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Eileen Edwards </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Scott Moir</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>11-Feb-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Beyonce Knowles</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Eileen Edwards </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Alexandre Bilodeau</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>14-Feb-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Beyonce Knowles</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Eileen Edwards </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Ashleigh McIvor</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Termination</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>18-Feb-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Joshua Chasez</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Robert Van Winckle</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Roberto Luongo</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">unauthorized absense</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Termination</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>4-Jan-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan" colSpan=2 height=17>Extracted formula result I'd like on sheet1: </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #a6a6a6" height=17>(A1) Ops Manager</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #a6a6a6">Manager</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #a6a6a6">Agent</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #a6a6a6">Topic</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #a6a6a6">Action</TD><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #a6a6a6">Date</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Joshua Chasez</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Robert Van Winckle</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Mark Tewksbury </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Letter 1</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>27-Jan-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Virginia Hensley </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Joanna Levesque </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">John Morris</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>27-Jan-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Joshua Chasez</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Anna Bullock</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Marc Kennedy</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>3-Feb-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Beyonce Knowles</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Eileen Edwards </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Tessa Virtue</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>9-Feb-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Beyonce Knowles</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Eileen Edwards </TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Tessa Virtue</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Attendance</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Discussion of concern</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>10-Feb-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #c4d79b" height=17>Joshua Chasez</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Robert Van Winckle</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Roberto Luongo</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">unauthorized absense</TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b">Termination</TD><TD class=xl64 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #c4d79b" align=right>4-Jan-11</TD></TR></TBODY></TABLE>
 
Sort by date Sort by votes
Hey Snoopyhr, your version takes about 3-5 seconds for the document to filter and update, which causes some issue with what I'm doing. Is there a way to make it faster? If not, I'll need to do the other one and figure out a button for refreshing the macro (which will be hell for me)!
 
Upvote 0

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Using Snoopy's sheet as a reference I would suggest using this macro:

Code: 
Sub Filter()

    Sheets("Sheet2").Select
    Application.CutCopyMode = False
    Dim R As Range
    R = Range("A1:F1")
    
        Sheet2.AutoFilterMode = False
        R.AutoFilter
        R.AutoFilter Field:=6, Criteria1:=">=" & Range("A18"), _
            Operator:=xlAnd, Criteria2:="<=" & Range("B18")
        LastRow = Range("F1").End(xlDown).Row
        Range("F1").Select
        Range(Selection, Selection.End(xlDown)).Select
        Selection.SpecialCells(xlCellTypeVisible).Copy
        Range("A20").Select
    
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        R.Select
        Selection.AutoFilter
        Application.CutCopyMode = False
                    
   End Sub
It sets an autofilter to the range, applies the dates and then copy/pasts only what is showing.

Sheet2

<table style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; " border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight:bold; width:30px; "><col style="width:121px;"><col style="width:114px;"><col style="width:136px;"><col style="width:102px;"><col style="width:146px;"><col style="width:67px;"></colgroup><tbody><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td>
</td><td>A</td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">1</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">(A5) Ops Manager</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">Manager</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">Agent</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">Topic</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">Action</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">Date</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">2</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Joshua Chasez</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Robert Van Winckle</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Mark Tewksbury</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Attendance</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Letter 1</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; text-align:right; ">27-Jan-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">3</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Joshua Chasez</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Mark Vincent</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Kevin Martin</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Attendance</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; text-align:right; ">11-Jan-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">4</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Virginia Hensley</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Joanna Levesque</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">John Morris</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Attendance</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; text-align:right; ">27-Jan-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">5</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Joshua Chasez</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Anna Bullock</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Marc Kennedy</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Attendance</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; text-align:right; ">3-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">6</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Cherilyn La Pierre</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Ben Hebert</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Attendance</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; text-align:right; ">16-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">7</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Eileen Edwards</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Tessa Virtue</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Attendance</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; text-align:right; ">9-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">8</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Eileen Edwards</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Tessa Virtue</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Attendance</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; text-align:right; ">10-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">9</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Eileen Edwards</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Scott Moir</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Attendance</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; text-align:right; ">11-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">10</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Eileen Edwards</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Alexandre Bilodeau</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Attendance</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; text-align:right; ">14-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">11</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Eileen Edwards</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Ashleigh McIvor</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Attendance</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Termination</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; text-align:right; ">18-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">12</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Joshua Chasez</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Robert Van Winckle</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Roberto Luongo</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">unauthorized absense</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; ">Termination</td><td style="background-color:#c0c0c0; color:#666699; font-weight:bold; font-size:8pt; text-align:right; ">4-Jan-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">13</td><td style="font-family:Verdana; font-size:8pt; ">
</td><td style="font-family:Verdana; font-size:8pt; ">
</td><td style="font-family:Verdana; font-size:8pt; ">
</td><td style="font-family:Verdana; font-size:8pt; ">
</td><td style="font-family:Verdana; font-size:8pt; ">
</td><td style="font-family:Verdana; font-size:8pt; ">
</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">14</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">15</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">16</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">17</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">Start Date</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">End Date</td><td style="font-family:Verdana; font-size:8pt; ">
</td><td style="font-family:Verdana; font-size:8pt; ">
</td><td style="font-family:Verdana; font-size:8pt; ">
</td><td style="font-family:Verdana; font-size:8pt; ">
</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">18</td><td style="font-size:8pt; text-align:right; ">1-Feb-11</td><td style="font-size:8pt; text-align:right; ">28-Feb-11</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">19</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td><td style="font-size:8pt; ">
</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">20</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">(A1) Ops Manager</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">Manager</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">Agent</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">Topic</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">Action</td><td style="background-color:#969696; font-weight:bold; font-size:8pt; ">Date</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">21</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Joshua Chasez</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Anna Bullock</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Marc Kennedy</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Attendance</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; text-align:right; ">3-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">22</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Cherilyn La Pierre</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Ben Hebert</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Attendance</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; text-align:right; ">16-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">23</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Eileen Edwards</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Tessa Virtue</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Attendance</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; text-align:right; ">9-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">24</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Eileen Edwards</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Tessa Virtue</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Attendance</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; text-align:right; ">10-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">25</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Eileen Edwards</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Scott Moir</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Attendance</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; text-align:right; ">11-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">26</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Eileen Edwards</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Alexandre Bilodeau</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Attendance</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Discussion of concern</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; text-align:right; ">14-Feb-11</td></tr><tr style="height:17px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">27</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Beyonce Knowles</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Eileen Edwards</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Ashleigh McIvor</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Attendance</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; ">Termination</td><td style="color:#666699; background-color:#c0c0c0; font-weight:bold; font-size:8pt; text-align:right; ">18-Feb-11</td></tr></tbody></table>
 
Upvote 0
Correction:

Code: 
Sub Filter()

    Sheets("Sheet2").Select
    Application.CutCopyMode = False
    Dim R As Range
    With Range("A1:F1")
    
        Sheet2.AutoFilterMode = False
        .AutoFilter
        .AutoFilter Field:=6, Criteria1:=">=" & Range("A18"), _
            Operator:=xlAnd, Criteria2:="<=" & Range("B18")
        LastRow = Range("F1").End(xlDown).Row
        Range("A1:F" & LastRow).Select
        
        Selection.SpecialCells(xlCellTypeVisible).Copy
        Range("A20").Select
    
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        .Select
        Selection.AutoFilter
        Application.CutCopyMode = False
        
        End With
                            
   End Sub

I know you are referencing data from different sheets, but that would be a simple tweak you could make to this code
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
435
smozgur
smozgur
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question
VBA for Web Scraping help
Replies
0
Views
845
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C

Forum statistics

Threads
1,221,418
Messages
6,159,790
Members
451,589
Latest member
Harold14

Share this page

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