01-29-2013, 09:20 AM | #1 | ||
Grizzled Veteran
Join Date: Jul 2007
Location: DeKalb, IL
|
Excel help
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.
__________________
|
||
01-29-2013, 09:41 AM | #2 |
Head Coach
Join Date: Oct 2000
Location: NYC
|
Not answering your direct question but what about setting this up as a Google Doc that everyone can access and input the data directly?
|
01-29-2013, 10:39 AM | #3 |
Grizzled Veteran
Join Date: Jul 2007
Location: DeKalb, IL
|
Hey Logan-
That's the fallback position that we're arguing for right now. The Administrative preference seems to be us e-mailing the document back-and-forth a ton of times between us and having one person responsible for turning it in but, from a discipline standpoint, punishing both teachers if the partner forgets to turn it in. |
01-29-2013, 10:57 AM | #4 |
Head Coach
Join Date: Oct 2000
Location: NYC
|
Yeah and even ignoring the discipline aspect, the administration should just be concerned about the colossal eff-up that would be caused by someone sending an older file than what the other person was using, and then going off that when tabulating the data. It typically ends in disaster when you have a small team of people doing that...can't imagine it from 48 sets of people.
|
01-29-2013, 11:43 AM | #5 |
College Prospect
Join Date: Nov 2006
Location: High and outside
|
If you can keep all the filenames consistent (InputBobble.xls, InputPurdueBrad.xls, etc.), then couldn't you just write a macro to open each file, copy, and paste?
|
01-29-2013, 02:38 PM | #6 | |
College Prospect
Join Date: Jan 2005
Location: Inland Empire, PRC
|
Quote:
This was going to be my suggestion.... Have a filename "standard" (HAHAHAHAHAHA) and it's easier. the cells on the secretary .xlsx would look like: =VLOOKUP($A857,'Z:\whatever\[filename.xls]sheetname'!$A$1:$F$65536,2,0) |
|
01-29-2013, 04:08 PM | #7 |
Grizzled Veteran
Join Date: Jul 2007
Location: DeKalb, IL
|
Thanks a ton guys, I'll run this by everyone!
|
01-29-2013, 04:09 PM | #8 | |
Head Coach
Join Date: Dec 2009
|
Quote:
pray |
|
01-29-2013, 04:30 PM | #9 |
Hall Of Famer
Join Date: Dec 2003
Location: the yo'
|
This clearly sounds like the worst possible way to do something.
Talk some sense into these people. |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|