Inventory Automation

Occasional Visitor

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:

  1. from populating the inventory sheet from the excel database,
  2. electronically checking and updating the inventory sheet rather than printing it and doing it manually,
  3. and then saving; printing and emailing the inventory sheet via push of a button for records keeping purposes
  4. to finally updating the database again via the inventory sheet again.

Would really appreciate some assistance in this regard.

1 Reply

@Mo_Rne Why not use the web version of Excel? You can collaborate with other users in real-time, so there's no need for emailing different versions back and forth.


Regarding all the copy/pasting, that's generally unnecessary. If you're trying to have different views of the data, just create a PivotTable. When you update your database, just refresh the PivotTable to see the latest data.



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies