I have three worksheets in my excel workbook as shown below.
I have a worksheet called Member List
Name Due Date Amount Paid
JohnDoe18 07-Feb-18 $124.00 Yes
JohnDoe19 08-Feb-18 $321.00 No <---From this record. Update to "Yes"
JohnDoe20 09-Feb-18 $333.00 No
JohnDoe1 10-Feb-18 $521.00 No
JohnDoe2 11-Feb-18 $333.00 No
JohnDoe3 12-Feb-18 $965.00 No
JohnDoe4 13-Feb-18 $145.00 No
JohnDoe5 14-Feb-18 $225.00 Yes
JohnDoe6 15-Feb-18 $336.00 No
JohnDoe7 16-Feb-18 $365.00 No
JohnDoe8 17-Feb-18 $124.00 Yes <---except this. I don't want to copy this
JohnDoe9 18-Feb-18 $321.00 No
JohnDoe10 19-Feb-18 $333.00 No
JohnDoe11 20-Feb-18 $521.00 No
JohnDoe12 21-Feb-18 $333.00 No <---To this record
JohnDoe13 22-Feb-18 $965.00 No
JohnDoe14 23-Feb-18 $145.00 No
JohnDoe15 24-Feb-18 $225.00 No
JohnDoe16 25-Feb-18 $336.00 No
JohnDoe17 26-Feb-18 $365.00 No
JohnDoe18 27-Feb-18 $124.00 No
JohnDoe19 28-Feb-18 $321.00 No
Worksheet named "Pay Period"
FirstDate LastDate PayDay
02-Nov-17 15-Nov-17 30-Nov-17
16-Nov-17 29-Nov-17 14-Dec-17
30-Nov-17 13-Dec-17 28-Dec-17
14-Dec-17 27-Dec-17 11-Jan-18
28-Dec-17 10-Jan-18 25-Jan-18
11-Jan-18 24-Jan-18 08-Feb-18
25-Jan-18 07-Feb-18 22-Feb-18
08-Feb-18 21-Feb-18 08-Mar-18 <---Today is 09FEB18 and falls in this pay period
22-Feb-18 07-Mar-18 22-Mar-18
08-Mar-18 21-Mar-18 05-Apr-18
22-Mar-18 04-Apr-18 19-Apr-18
05-Apr-18 18-Apr-18 03-May-18
19-Apr-18 02-May-18 17-May-18
03-May-18 16-May-18 31-May-18
17-May-18 30-May-18 14-Jun-18
31-May-18 13-Jun-18 28-Jun-18
14-Jun-18 27-Jun-18 12-Jul-18
Worksheet "Report"
Name Due Date Amount
JohnDoe19 08-Feb-18 $321.00
JohnDoe20 09-Feb-18 $333.00
JohnDoe1 10-Feb-18 $521.00
JohnDoe2 11-Feb-18 $333.00
JohnDoe3 12-Feb-18 $965.00
JohnDoe4 13-Feb-18 $145.00
JohnDoe6 15-Feb-18 $336.00
JohnDoe7 16-Feb-18 $365.00
JohnDoe8 17-Feb-18 $124.00
JohnDoe9 18-Feb-18 $321.00
JohnDoe10 19-Feb-18 $333.00
JohnDoe11 20-Feb-18 $521.00
JohnDoe12 21-Feb-18 $333.00
I want to copy the records falling between 08FEB18 and 21FEB18 with a string "No" in the fourth column into the worksheet "Report" and update the "No" to "Yes" in "MemberList".
I am a beginner in excel and need help to write a macro for this task
Thank you very much.
Regards
Raghu