I need a formula or a macro that can copy specific column A data into Column B, C and D
Please check the attached sample file and let me know If you have any questions.
A couple of examples are there.. I want the solution so that I can apply it to the other files I have..
Please note that the Year range might be presented differently. So you solution must cover all the aspects...
I need the solution in the next couple of hours..