Recommendations (macro)??

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I am building a database in excel that is rather large. I
am not proficient with the use of macros and I can only
assume this would help create what I am looking for. Any
recommendations on a how to learn (books, tutorials, etc.)
other than spending alot of money on a class would be
appreciated.

Thanks.
 
A database in Excel is a glorified list. You don't really need an extensive
knowledge of macros to enter a list in an Excel worksheet. But if you want
to add automated functionality to it, then of course, you need macros.
Check out your local book store. John Walkenbach's books ("Power
Programming...") are widely available and highly regarded.
 
Depending on your data, and if it is truly in database format, then take a look
at Data / Filter / Autofilter (And Advanced Filter), and also take a look at
Pivot Tables, both of which will allow you to do some great analysis. Debra
Dalgleish has some great intros for both at the following links (With not a hint
of a macro in sight):-

http://www.contextures.com/xlautofilter01.html

http://www.contextures.com/xladvfilter01.html

http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm

As far as books go, if you are learning Excel, then maybe John Walkenbach's
Excel Bible will do you, as this covers normal Excel functions as well as Excel
Macros (VBA). 2000 or 2003 come with a CD. Again, Debra Dalgleish has a list
on her site :-)

http://www.contextures.com/xlbooks.html
 
Thanks for the suggestions.
-----Original Message-----
But specifically for macros, I would have gone with Jim's choice also.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

---------------------------------------------------------- ------------------
It's easier to beg forgiveness than ask permission :-)
---------------------------------------------------------- ------------------



format, then take a
look following links (With not a
hint http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart
..htm functions as well as
Excel


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.572 / Virus Database: 362 - Release Date: 27/01/2004


.
Click to expand...
 
The file is actually not in database format and I am
trying to automate several things in the workbook which
will be used by others. Thanks for the suggestions.
 
Back
Top