Forum Discussion
creating a table/new work book that filters data
That's a tall order, not one I'm equipped to handle. You say that the guys in the field don't have tech, which is kind of surprising. Do they have iPads? If they do, they would be able to use an iPad to enter directly into the spreadsheet. I'm not at all confident that the scanning of a handwritten document would be able to get the data cleanly into the sheet in the appropriate spot, etc.
But from here (seeing only the tip of the iceberg), it seems to me that you should be talking with a local IT person about the whole process of gathering and summarizing the data.......
As I suggested in my last post, if you are able to post a copy of the actual spreadsheet, so long as it's not violating any proprietary guidelines, I and others could take a look at it in more detail. Absent that, though, there's not a lot more to suggest.
ive attached a blank copy of the form that is filled out.
in the field they dont use tablets as they are generally covered in dirt, rainy weather and dont have the time to add it to the table and we like the paper copies.
just trying to make it easier at the end of the day and for me to get multiple years of data together
we are planning on making multiple pages within the sheet to move each location to so its only one per page