To be honest, I don't roam around a lot looking for code solutions - I
probably should do more of that since they almost always teach something new.

But an excellent book on practical programming within Excel was written by
John Walkenbach - I have a copy titled "Excel 2000 Power Programming with
VBA" (ISBN 0-7645-3263-4, and I believe there's an updated edition "Excel
2003 ..." Should be available through Amazon or your local Barnes & Noble,
Borders, etc.

"Aine" wrote:

That would be ideal.

Have a good background in programming & logic, but have never touched
macros
I normally work with databases but the company I am contracting for
want it all through excel for visibility purposes(plus they prefer us
not to use MS Access)

Do you know any good site with macros tutorials for these types of
queries?