Macros?

[Brien]

I have been asked to streamline some time consuming data analysis (as I
have mentioned with a different thread about a different question) and
I'm wondering if Macros can help me.

The manual process involves creating Excel documents from 4 CSV
documents, then lots of cutting and pasting of values from one location
to another. Then a few calculations are made and put into pretty graphs
before being exported to word as a finished document.

How much of this can be automated? Are macros the way to go? As far as I
can tell, Macro's are embedded in a document aren't they? How can I
create a macro of the entire process and then let a new document be made
to do the whole thing again with 4 different CSV files? And then
again, from scratch etc.

I hope this is making sense. I'm new to this and been thrown in at the
deep end. My brain is hurting.

Brien
(sorry for cross post. I just noticed that this group seemed a lot more
active than that first I posted in)

 

[Debra Dalgleish]

You can record a macro as you do the process manually, and store the
macro in personal.xls or another workbook that's always open.

The macro would probably need some fine tuning, to make it flexible
enough to adapt to files that contain different amounts of data. If you
get stuck, you can post specific questions here, and include the code
and a description of your files.