I am working on an inventory tracking workbook for our organization and am looking to solve a few questions. My main question would be this, is there any way to script out, or use a macro to find totals using variables so to speak.
We will have a sheet (see attached) with machine information and schools in which the machine is located and what type of machine it is.
For instance one machine could be located at the high school, be a student computer, and it would be a laptop, in a lab environment. What i would like to do is be able to grab totals for each on a dashboard like frontend so we can see this at a glance so it would look something like "High School, Student, Lab, Laptops = 156" for example.
The main reason for doing this is for reporting at the end of the year to the state. Will make life so much easier if this is possible.
We will mark the variables with ones so we can get totals on laptops, desktops, ect...
That is question one of like 5. Would like to solve these one at a time.
If you need anything cleared up or more explanation just let me know.
(attached version is not the final revision of the document)
Bookmarks