Hi Experts...
I have data set which is driven by a condition. The driving condition is month, based on the month in A1, the data from B1 to B20 to be copied and pasted as value in sheet 2.
Sheet 2 have Months defined as column headers (A1 to X1). There is a blank column between two months. The function should match the month specified in Sheet1 A1 to Sheet 2, copy data B1 to B20 right under the matching criteria header. It should get updated for month specified in condition till months till year end...
Please help..
Sample file attached
Bookmarks