Excel 2007 : Formatting an exported Excel document

Folks,

I've been handballed the task of turning and Excel export from our MIS into meaningful data. At the moment the MIS exports a whole bunch of fields as "Untitiled.xls", which I want to then remove inappropriate columns, sort, put in headings, etc etc. I'd imagine the best way to do this would be to link the data from Untitled.xls into a formatted excel doc (call it Formatted.xls). That said, I am by no means an Excel guru. Quite the opposite actually (as you can no doubt already tell).

I realise this is all very vague, but I'm not expecting someone to give me the definitive answer (although that would be nice), rather just to put me on the right path.

Thanks in advance!

HP

You'd need to use VBA for that.
Either you ask someone to code you an exact formula or you record your own macro, which will work just as well but might be a bit bulkier in size (mind you, its an extra 1-2KB)

If you go with record, Turn Record on, then do what you need to do, i.e. select the columns you want to get rid off, then delete them. Then insert row at top row and type header names. Then use custom sort to sort them the way you wnt to. Then stop recording.

Next time you get a similar layout export, you just run the macro you just recorded.