I’m importing some excels in a loop. The excels are supposed to have the exact same headings but sometimes there are four initial columns (A to D) that shouldnt be there - these four columns always have the same headings. After columnd D the excel is as it should be.
I would like to do a check the data table something like this:
- IF (Column A = “Heading1” and Column B = “Heading2” and Column C = “Heading3” and Column D = “Heading4”)
Then remove column A, B, C, and D
This is the current loop: