[CrimsonFox]

Originally Posted by PurdueBrad

Hey all,

I'm not sure if what I'm asking is possible but here's the situation.

I work in a school and the administration is trying to collect daily data from 48 pairs of teachers using Excel spreadsheets. We don't have a shared drive so either teachers are submitting their files individually (96 files) or constantly e-mailing back and forth and submitting jointly (48 files). These files, although they track daily data, would be turned in monthly. The data tabulation would be rough as the current plan is for a secretary to wade through each file and add the numbers to her own spreadsheet.

However, I thought there might be a way to simply import the data from all those separate files and have Excel do all the work rather than 1 person. Is this possible and, if so, how so?

I'm not really involved in the project but I'm just trying to find a shortcut to make a couple people's lives easier.

pray