I have two sheets as follows;
Sheet 1
-----------------------------------------1-April----1-May---1-June---1-July....so forth
-----------------------------------------30-April--31-May--30-June--31-July....so forth
User ID | Supplier | Payment Type |_______|_______|_______|_______|
Sheet 2
User ID | Supplier | Payment Type | Start Date | End Date | Total Amount
What I need to do is match UserID, Supplier, Payment Type and get the monthly amount into the months in sheet 1 using the data from sheet 2, but the start and end date could be anything, and the total is for that entire period. So in sheet 1 the months are 1-April-2016 - 31-Mar-2017 but the start end date in sheet 2 could be e.g. 1/7/2015 - 18/12/2016 with a Total of £4300 (Days x daily rate). Is this possible?
Sheet 1
-----------------------------------------1-April----1-May---1-June---1-July....so forth
-----------------------------------------30-April--31-May--30-June--31-July....so forth
User ID | Supplier | Payment Type |_______|_______|_______|_______|
Sheet 2
User ID | Supplier | Payment Type | Start Date | End Date | Total Amount
What I need to do is match UserID, Supplier, Payment Type and get the monthly amount into the months in sheet 1 using the data from sheet 2, but the start and end date could be anything, and the total is for that entire period. So in sheet 1 the months are 1-April-2016 - 31-Mar-2017 but the start end date in sheet 2 could be e.g. 1/7/2015 - 18/12/2016 with a Total of £4300 (Days x daily rate). Is this possible?
