I have a table below which is the source, information which might have 100 rows or more. Then I have another table in the same sheet with Months Header which also be dynamic but it will be until December. I need to copy all the Names in the Months column while looking at their birthday. How to do that in vba in dynamic way? Thank you.
Source
Name Address Birthday Email Address Team Joe Canada 03-Jun-1986 [email protected] Team1 Marie Switzerland 21-Jan-1977 [email protected] Team2 Desirie Malaysia 26-Jul-1988 [email protected] Team3 Elise Japan 07-Aug-1990 [email protected] Team4 John Singapore 31-Jan-1991 [email protected] Team5
Destination
January February March April May June July August September October November December
Outcome would be:
January February March April May June July August September October November December John Joe Desirie Elise Marie
Bookmarks