Cross Referencing Multiple Cycles of one Plan
We have Plan A with Same Extract Date say 31-Dec-2021 and with multiple cycles say 2023 , 2024, 2025 etc . Each of these cycles have a worksheet column say Total Amt-Yr1, Total Amt-Yr2, Total Amt-Yr3 where Yr1,Yr2 and Yr3 are 2023 , 2024, 2025 respectively.
Requirement is to copy the values of Total Amt-Yr1, Total Amt-Yr2, Total Amt-Yr3 into Plan B which has same cycle extract Date which is 31-Dec-2021 , however has only one cycle say 2022. Is it Possible to achieve?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):