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:
<tbody>
</tbody>
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:
Date | Source | Name | Phone | Comments | Max Budget | Active | Appointment | |
2/4/19 | REA | John Smith | comment A | X | ||||
3/4/19 | REA | Alan Jones | comment B | |||||
4/4/19 | Domain | Mike Roberts | comment C | X | ||||
5/4/19 | Website | Alice May | comment D | |||||
6/4/19 | Matt Otway | comment E | X | X |
<tbody>
</tbody>
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.