how can I take multiple sperate spreadsheets with the same formats, columns, rows fromulas everything identical except data. then make 1 speadsheet or sortable data base.
Use different SQL statements that produce the same number of columns but actually get the different data you want displayed. Then just slap together one template spreadsheet. Every row in teh spreadsheet will get filled based on the SQL results.
AaronZoller.com
