Hi There,
Some background: We perform Asset Management functions for our department which means working from a particular excel database, manually copying and pasting information from there into an inventory list, printing out that list and then checking the items, coming back to the office and updating the database again which is very time consuming.
If the whole process could be automated:
- from populating the inventory sheet from the excel database,
- electronically checking and updating the inventory sheet rather than printing it and doing it manually,
- and then saving; printing and emailing the inventory sheet via push of a button for records keeping purposes
- to finally updating the database again via the inventory sheet again.
Would really appreciate some assistance in this regard.