ambern1023
New member
I need to create an excel workbook that is will sheets for all of our vehicle's maintenance, parts purchased etc. then 1 workbook that keeps full historical info of all vehicles, then another one for services to "check regular with conditional highlighting. I currently use a Microsoft form to get info to a spreadsheet, so I need it to be linked to that workbook so when new entries come in it auto populates the info to the main linked workbook and then ideally to the appropriate vehicle sheet in that same workbook and well as to historical.
I'm not sure how to make it go to the check regularly i may have to do those updates myself,
we purchased ALOT of parts for our vehicles as it is heavy truck with lots of attachments, so we need to keep track of the parts purchase with part #, cost and vendor purchased from by vehicle as well.
what is my best approach to this to track service history, parts, needed repairs, and history of all services? We have 7 Vehicles now.
Also it appears when using excel online (we use Dropbox i am getting a notification that links to other workbooks are not supported online. What should I be using as my boss prefers us to use the online versions through our Dropbox to prevent conflicted copies. however not all features are available with online,
what do i do here?
I'm not sure how to make it go to the check regularly i may have to do those updates myself,
we purchased ALOT of parts for our vehicles as it is heavy truck with lots of attachments, so we need to keep track of the parts purchase with part #, cost and vendor purchased from by vehicle as well.
what is my best approach to this to track service history, parts, needed repairs, and history of all services? We have 7 Vehicles now.
Also it appears when using excel online (we use Dropbox i am getting a notification that links to other workbooks are not supported online. What should I be using as my boss prefers us to use the online versions through our Dropbox to prevent conflicted copies. however not all features are available with online,
what do i do here?