[sheflug] Slightly Off-Topic, Openoffice Help

[Ashe <ashe [at] xxxxxxxxxxxxxxxxxx>]

Can anyone point me towards a decent reference or bit of info that can 
tell me how I'd do the following?

I have a bunch of calc spreadsheets, each of which has a sheet which is 
an attendance roster. I need some method of iterating through each file, 
  extracting the data from that one sheet in each file, and writing out 
another spreadsheet with, for example: Name, Member Number, Count of 
Attendances.

Am I better copying all those sheets into another file and working on it 
from there? Is this something I can do with the built-in functions, or 
am I going to have to start faffing round with basic and stuff?

AH
-- 
"Unless I grip the sword, I cannot protect you.
While gripping the sword, I cannot embrace you."

___________________________________________________________________

Sheffield Linux User's Group -
http://www.sheflug.co.uk/mailfaq.html

  GNU the choice of a complete generation.