Attached please find a sample of what I'm dealing with.
Criteria 1 : Paste the relevant fields if the status is "In Progress" from Data to Summary Sheet.
Criteria 2 : Paste the activities data which is due in 7 days of "Today's Date" and the activities which are prior to "Today's date".
Basically when the user opens the summary sheet he should be able to see the activities missed from that date opened and which are due in next 7 days.
Thanks,
Pavan.
Criteria 1 : Paste the relevant fields if the status is "In Progress" from Data to Summary Sheet.
Criteria 2 : Paste the activities data which is due in 7 days of "Today's Date" and the activities which are prior to "Today's date".
Basically when the user opens the summary sheet he should be able to see the activities missed from that date opened and which are due in next 7 days.
Thanks,
Pavan.
