Forum Discussion
Inventory Automation
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 ...
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.
HTH