Hi everyone

Usually, I receive an excel report that has certain vital column headings, but there are times that a few of them are missing.

What I would like is a macro that determines if these headings exist and if they do not, to add that heading in the last unpopulated column.

So let's say my required headings are: Head1 , Head2, and Head3

So the macro logic would be like:
- Check if Head1 exists. If it does, then do nothing and check the next. If not, then add Head1 to the next unpopulated column (row 1).
- Then check if Head2 exists. If it does, then do nothing and check the next. If not, then add Head2 to the next unpopulated column (row 1). And vice versa.

Any assistance would be very much appreciated.