Hello,
I have a sheet named 'caseload' where data is entered into columns A,B,C and D. Column D is the date the booking was completed. This data will be entered by different people as they complete the 'booking'
I have further worksheets by Month/Year where further information is added and calculations undertaken.
I currently just link the cells in caseload to January_2020.
As each row of cells B,C,D and E of 'caseload' are completed, I want to copy the information in B, C and D to the relevant sheet based on month.
So in my document, data in caseload B1/2/5, C1/2/5 and D1/2/5 would copy to January_2020 B1/2/3, C1/2/3 and D1/2/3 respectively as the booking dates (E1,2,5) took place in January 2020 and data in caseload B3/4, C3/4 and D3/4 would copy to February_2020 B1/2, C1/2 and D1/2 respectively as those booking dates (E3/4) took place in February 2020.
I have tried LOOKUP and VLOOKUP with MONTH and DAY but failed and I don't have FILTER on my Mac Excel 2019...
thank you.
Bookmarks