Hi Forum,
I am trying to create a macro that is able to delete entire columns in sheet1, which don't have the same title in first row in sheet2. I find a macro a lot easier, since I got 7000+ columns.
For example, column E in sheet 2 with title "Return (Day to Day) 2015-05-28 to 2015-05-28 USD" has identical title in sheet1, so this shouldn't be deleted. However, column F in sheet 2 with title "Return (Day to Day) 2015-05-26 to 2015-05-26 USD" is an identical titel, and should therefore be deleted.
Any help is deeply appreciated.
Bookmarks