Hello everyone. I need help with the following:
each person in column B will have its own sheet. Within each person sheet Range("C14:C373") will have dates
Using the above Table I need a Macro to copy the Paid amount for each individual to its sheet in column F, matching date in Cell (B55) "MM/YYYY" to the date in Range for each person ("C14:C373")
using above example
sheet(JOHN) cell C24 = 2/5/2021
value in F24 = $50.00
sheet(BILL) cell C300 = 2/15/2021
value in F300 = $1000.00
sheet(TOM) cell C14 = 2/1/2021
value in F14 = $29.00
sheet(SARA) cell C240 = 2/5/2021
value in F240 = $200.00
sheet(KIM) cell C204 = 2/28/2021
value in F204 = $20.00
Notice the Day is not important so only match the Date "MM/YYYY" to the "MM/YYYY" to each sheet in Range("C14:C373")
also the date MM/YYYY will not be duplicated.
note: the Name and paid amount could be 1 person to 7 people.
any help is greatly appreciated.
Date of Payment | 2/15/2021 | |
Paid To | JOHN | $50.00 |
Paid To | BILL | $100.00 |
Paid To | TOM | $29.00 |
Paid To | SARA | $200.00 |
Paid To | KIM | $20.00 |
Paid To | ||
Paid To | ||
each person in column B will have its own sheet. Within each person sheet Range("C14:C373") will have dates
Using the above Table I need a Macro to copy the Paid amount for each individual to its sheet in column F, matching date in Cell (B55) "MM/YYYY" to the date in Range for each person ("C14:C373")
using above example
sheet(JOHN) cell C24 = 2/5/2021
value in F24 = $50.00
sheet(BILL) cell C300 = 2/15/2021
value in F300 = $1000.00
sheet(TOM) cell C14 = 2/1/2021
value in F14 = $29.00
sheet(SARA) cell C240 = 2/5/2021
value in F240 = $200.00
sheet(KIM) cell C204 = 2/28/2021
value in F204 = $20.00
Notice the Day is not important so only match the Date "MM/YYYY" to the "MM/YYYY" to each sheet in Range("C14:C373")
also the date MM/YYYY will not be duplicated.
note: the Name and paid amount could be 1 person to 7 people.
any help is greatly appreciated.