Forum Discussion
creating a table/new work book that filters data
we are try8ing to move each "section" of this sheet to its own page then have a sheet for each year with each "location" on a new page and then we want to be able to sort the data based on different variables when we need to and keep building new years onto it as we do this job a few times a year and need to be able to review previous notes/info from the last times we did it etc
please help lmk if theres a better way (we also need to be able to print this for our guys in the field to use as they dont have tech in the field and they will then handwrite new notes for the day and it will need to be added to the sheet for that year(hopefully microsoft lens would be able to read the handwritten notes on a blank sheet exactly the same as the workbook and insert into the corrrect columns if we scan it in? or do you know of a way to do this?)
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.
- how do i put each set of data on a new page on the same sheet so I can print them individually
how do i put each set of data on a new page on the same sheet so I can print them individually
There is a way to insert page breaks between rows, if that's what you're asking. Use the Insert menu at the top:
But I wonder, seriously, whether Excel is what you should (or need to) be using. As I said right off the bat, you're not really using Excel (or don't appear to be) for what Excel offers in the way of calculations, data manipulation, etc. You're using it for its array of rows and columns. It's basically a high-tech ledger sheet for you. (Unless, as also noted above, I'm missing some off-the-screen processes that haven't been discussed.)
Just to illustrate what I mean, I've created a Word document that has all the same columns. And using the Word Table layout, you get the same array of rows and columns. There's no limit to the amount of text that can be put in any cell in Word......
And pagination, although available in Excel, is "more natural" in Word. It's more readily apparent where and how to insert page breaks when needed. Granted, it would be trickier to get those few totals that you do have in your sample......
Again, if it's possible to post a copy of the actual workbook, so I and others (e.g., peiyezhu ) could take a look at it, that might yield some more useful suggestions. You were able to post that PDF of the data gathering sheet, so it would appear that you are able to post the Excel workbook as well.
mathetes
here is a copy of a previous years log recordwe have since added onto it by sorting location alphabetically and we need to find a way to add previous years data to keep going historically or appened? so we can review previous years notes etc from that location and be able to print it out on a sheet for the guys in the field to easily view then a way to update the sheet for the day with new info after
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