A non dependency on DataDump content

A bit of help needed guys.

Im operating a macro at the moment that populates excel files with content taken from a Data Dump. The data dump itself contains a large amount of information and columns.
Im trying to figure out a way to make it possible to include new or extra columns within the data dump (varieing from week to week) that wont upset the code and will return the new column with in all the populated excel files (or even into specific files if possible).

Ive included a sample of the code for my macro and a sample of one of the formating macros below.
Any assistance on this would be greatly apreciated as Im really at a loss for ideas on this.


Parent Macro Code

Please Login or Register  to view this content.

Formating Macro code to follow

Formating Macro
Formating Macro

Please Login or Register  to view this content.

Any takers?

Not really sure what you're doing. Can you post a sample workbook?