Reverend
New Member
- Joined
- May 24, 2006
- Messages
- 8
I have been using a spreadsheet to log computer users in the computer lab that I work at.
It is time for me to prepare a quarterly report for the organization that finances the computer lab and I would like help automating this process.
I have 3 months of excel files (one file for each day) seperated into three different folders (one folder for each month). Files are named in the following way YYYYMMDD.xls. I would like to create a spreadsheet that can look at all the other spread sheets and sort and pull the following information.
-how many total users? (for the three month period)
- how many users selected the "National Guard" value
- of National Guard users how many were here for TRAINING and how many for EDUCATIONAL.
- how many users selected the "Army" value
- of ARMY users how many were here for TRAINING and how many for EDUCATIONAL.
- how many users selected the "Civilian" value
- of CIVILIAN users how many were here for TRAINING and how many for EDUCATIONAL.
- how many users selected the "Family member" value
- Also how many were for TRAINING and how many for EDUCATIONAL
- how many users selected the "Other" value.
- Also how many were for TRAINING and how many for EDUCATIONAL
I can send a sample of the LOGIN sheet spreadsheet and a copy of the QUARTER report spread sheet if needed. Also I see there are utilities offered that I can post screen shots of the spreadsheets if the would be helpful. Or if anyone can help me come up with some key terms that I can google to find help performing the type of sorting and importing actions that I need. I'm sure it is a simple enough process, but I have no experience working with excel formulas that call on accessing seperate excel documents. Any help will be much appreciated.
It is time for me to prepare a quarterly report for the organization that finances the computer lab and I would like help automating this process.
I have 3 months of excel files (one file for each day) seperated into three different folders (one folder for each month). Files are named in the following way YYYYMMDD.xls. I would like to create a spreadsheet that can look at all the other spread sheets and sort and pull the following information.
-how many total users? (for the three month period)
- how many users selected the "National Guard" value
- of National Guard users how many were here for TRAINING and how many for EDUCATIONAL.
- how many users selected the "Army" value
- of ARMY users how many were here for TRAINING and how many for EDUCATIONAL.
- how many users selected the "Civilian" value
- of CIVILIAN users how many were here for TRAINING and how many for EDUCATIONAL.
- how many users selected the "Family member" value
- Also how many were for TRAINING and how many for EDUCATIONAL
- how many users selected the "Other" value.
- Also how many were for TRAINING and how many for EDUCATIONAL
I can send a sample of the LOGIN sheet spreadsheet and a copy of the QUARTER report spread sheet if needed. Also I see there are utilities offered that I can post screen shots of the spreadsheets if the would be helpful. Or if anyone can help me come up with some key terms that I can google to find help performing the type of sorting and importing actions that I need. I'm sure it is a simple enough process, but I have no experience working with excel formulas that call on accessing seperate excel documents. Any help will be much appreciated.