Hi all!
I'm new to the Excel group; I develop in Access. Here's my
question/dillemma:

I have a client that needs to see there data in XLS format, thus I created a
script from within Access to dump a specific Crosstab Query into an XLS work
sheet. The client now wants to see the data grouped by specific criteria
(Divisions) within seperate workbooks in 1 spreadsheet. I almost sure that I
can't specify workbooks from with MS Acces; thus I need a way of automating
this process from with Excel. Obviously this can be achieved by creating a
macro, but I don't know where to start. Example:

I want to look at the 1st column (Division) and copy every corresponding
cell that meets that specific Division criteria to a worksheet.

Any thoughts?
Thanks in advance!
Anthony Viscomi