Hi guys, need your help once again.
the situation is the following:
I have hundreds of csv files to process daily. To make my life easirer i created a batch file to merge them automatically in a brand new file. The thing is that each file has a header, which is in the bulk as well. So in a merged csv i have at about hundred headers that i want to get rid off, except for the original header - row 1. The headers are layed out in exactly the same way and are unique compared to the csv content.

What i would like is a macro to delete the rows containing "EmailAddress" except for row 1.
And would you explain how exactly can i make this global, so each time i open the csv file, i could go to Macros and execute it.