Can you program Excel to auto format a recurring import?

[jdfundas]

Ello ello,

I have to import the same 3 documents each night and format them (deleting columns, rearranging columns, deleting certain criteria...) Is there a way I can program Excel, or another program, to auto format the imports for me? I format them the same each night, the documents come in the same format each night. It seems plausible, I just don't know how..

Thanks,

 

[ParamRay]

.
.

A good starting point would be to use Excel's macro recorder to record your actions while you're carrying out the formatting changes. You can then play back the recorded macro and see if it works as expected.

The recorded macro will more than likely need to be cleaned up and modified slightly to work efficiently. To do this, you'll need to review/rewrite the code or get some assistance from somebody who has knowledge of VBA...