Hello All,

I'm new to this forum so please take it easy on me and thank you in advance to anyone looking to help.

I recieve sales data from my wholesalers every month and I continually have to format them to fit the structure of our in-house database. I wanted to design a macro that would automate this process. However, in some months, the files are recieved in a format that is a bit different from the wholesaler's usual format.

Anyone have any suggestions on automating this process?

Is there such thing as an initial "litmus" test where I could try running the macro and if it doesn't fit the usual structure, there's an error code and I could do it by hand?

Any other suggestions? Anything helps!