Really hoping that someone can help and I think this issue is driving me crazy.
I have designed a Macro that takes a load of raw data and formats in. This works a charm however every now and again an extra column appears called Delivery Priority. This of course throws all the other caluations out. I therefore require some coding that will look at the coloums (It normally is Q but can also appear in others) and delete this. Not sure if this matters however the wording is in row 10