I want to pull in the names and comments from the Detailed sheet onto the Snapshot based on a date range and a critera.
The criteria is that Active or Appointment are not populated with X.
Detailed:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Source[/TD]
[TD]Name[/TD]
[TD]Phone[/TD]
[TD]Email[/TD]
[TD]Comments[/TD]
[TD]Max Budget[/TD]
[TD]Active[/TD]
[TD]Appointment[/TD]
[/TR]
[TR]
[TD]2/4/19[/TD]
[TD]REA[/TD]
[TD]John Smith[/TD]
[TD][/TD]
[TD][/TD]
[TD]comment A[/TD]
[TD][/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3/4/19[/TD]
[TD]REA[/TD]
[TD]Alan Jones[/TD]
[TD][/TD]
[TD][/TD]
[TD]comment B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4/4/19[/TD]
[TD]Domain[/TD]
[TD]Mike Roberts[/TD]
[TD][/TD]
[TD][/TD]
[TD]comment C[/TD]
[TD][/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/4/19[/TD]
[TD]Website[/TD]
[TD]Alice May[/TD]
[TD][/TD]
[TD][/TD]
[TD]comment D[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/4/19[/TD]
[TD]Facebook[/TD]
[TD]Matt Otway[/TD]
[TD][/TD]
[TD][/TD]
[TD]comment E[/TD]
[TD][/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
</tbody>[/TABLE]
So the following would be pulled into the Snapshot sheet based on the date range of April 2 - April 6:
Alan Jones Comment B
Alice May Comment D
Each week, Snapshot names and comments will be over-written based on the new week.
The criteria is that Active or Appointment are not populated with X.
Detailed:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Source[/TD]
[TD]Name[/TD]
[TD]Phone[/TD]
[TD]Email[/TD]
[TD]Comments[/TD]
[TD]Max Budget[/TD]
[TD]Active[/TD]
[TD]Appointment[/TD]
[/TR]
[TR]
[TD]2/4/19[/TD]
[TD]REA[/TD]
[TD]John Smith[/TD]
[TD][/TD]
[TD][/TD]
[TD]comment A[/TD]
[TD][/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3/4/19[/TD]
[TD]REA[/TD]
[TD]Alan Jones[/TD]
[TD][/TD]
[TD][/TD]
[TD]comment B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4/4/19[/TD]
[TD]Domain[/TD]
[TD]Mike Roberts[/TD]
[TD][/TD]
[TD][/TD]
[TD]comment C[/TD]
[TD][/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/4/19[/TD]
[TD]Website[/TD]
[TD]Alice May[/TD]
[TD][/TD]
[TD][/TD]
[TD]comment D[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/4/19[/TD]
[TD]Facebook[/TD]
[TD]Matt Otway[/TD]
[TD][/TD]
[TD][/TD]
[TD]comment E[/TD]
[TD][/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
</tbody>[/TABLE]
So the following would be pulled into the Snapshot sheet based on the date range of April 2 - April 6:
Alan Jones Comment B
Alice May Comment D
Each week, Snapshot names and comments will be over-written based on the new week.