Forum Discussion
creating a table/new work book that filters data
I need to create a new table based off the info from one year and add the same columns for this year so it can be easily seen the same sections year to year i need this data in a new sheet or tab...
There's nothing particularly wrong about that, but it's also (for that reason, I suspect) why more than 60 folks here have viewed your inquiry without responding: it's not really an Excel question, per se; at least not a question that looks to take advantage of the real strengths of Excel.
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?)
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?)