automating excel operations

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have some output from a program that I am running through excel to
extract some stats and create some graphs. I was looking to automate
some of the manual process and did not know how that could be done (VB,
macros??). Here are some of the operations that I'm doing:

1. Importing data, separated by commas
2. Sort the data by certain columns
3. Do the data/filter/advanced filter to get all the unique values from
a column and copy them to another sheet
4. enter in formulas to calculate values (need to update ranges a lot
but most of it is copy/paste possible).
5. When I create this new page of data, can I create some type of
template (or I guess a worksheet that is a templet) for the graphs so I
don't have to recreate them?


Thanks,

Frank
 
The short answer is "Yes, you can do all those things".

How you do them is very dependent on your particular situation, and
asking for a comprehensive solution is beyond the scope of this
newsgroup (posts about macros should generally be directed to the
microsoft.public.excel.programming group).

You might try recording macros for your steps. If you're unfamiliar
with macros, take a look at David McRitchie's site:

Getting Started with Macros and User Defined Functions
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Whatever code you record will undoubtedly need to be revised, but it
will likely comprise a good start. Post back when you need help with
particular chunks.
 
Back
Top