Hi Team,
A very good evening,
I have an input file where there are different exchanges codes and their holidays list. i have them in jumbled format with month wise . now i want a macro which can take the reference of exchange code(Since they are more accurate in original sheet) and Sort down the data in such a way that For an exchange code all the holidays in an year should come in sequence. for example if i have an exchange code as "AU" in the exchange code column the macro should search for "AU" in whole sheet and copy the data for all the twelve months and paste it in next sheet in a sequence and again it should go to second exchange code and do the same thing.
I had attached the sample sheet and desired sheet for your reference . thanks for your help in advance ... any help will be much appreciated......
Bookmarks