my data is copied across 3 different worksheets.
i am trying to modify my loop so that it will search through row 1 and find specific headers and delete those columns on sheet2 and on the subsequent sheet (sheet3) delete only the opposite of what is listed in the headers. thus keeping sheet1's original data untouched.
