Yes, what you want to do is possible.

You haven't provided enough information to answer your other questions. If you are using VBA code then either an array or lots of variables can be used. If the data is coming from a database then perhaps a recordset from a sql query would make the most sense to use.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia