Hi all, I'm a noob at vba and am trying to figure out how to get this to work. Would anyone be able to advise me please?
Basically, there are 2 workbooks here - A and B. I would like to find the date in Workbook A column 1 (refer to table below), copy the Teams assigned to work that day, find the matching date in Workbook B and paste it. However, workbook B is split into various months (Jan 2022, Feb 2022, Mar 2022).
How can I get the month from column 1 of Workbook A to find the matching tab in Workbook B and copy paste columns 3 and 4 into the "Jan 2022" worksheet of Workbook B based on the exact date in Workbook A which is 1 Jan and 2 Jan?
Workbook A
Thank you!
Basically, there are 2 workbooks here - A and B. I would like to find the date in Workbook A column 1 (refer to table below), copy the Teams assigned to work that day, find the matching date in Workbook B and paste it. However, workbook B is split into various months (Jan 2022, Feb 2022, Mar 2022).
How can I get the month from column 1 of Workbook A to find the matching tab in Workbook B and copy paste columns 3 and 4 into the "Jan 2022" worksheet of Workbook B based on the exact date in Workbook A which is 1 Jan and 2 Jan?
Workbook A
| 1 Jan | Weekend | Team A | Team B |
| 2 Jan | Weekend | Team B | Team C |
Thank you!
