Forum Discussion
Connecting Separate Excel sheets for Asset Management
Hi, am working on a simple asset management solution for my company using Excel. The spreadsheets will eventually become data sources for a power app that will make the asset tracking more user frien...
I’ve worked on similar setups before, and it’s definitely possible to link the data between two sheets like you’re describing. You can use Excel’s VLOOKUP or INDEX/MATCH functions to pull data from one sheet into another. For example, when an employee is assigned a laptop in the inventory sheet, you can have a formula that automatically updates the "Laptop" column in the employee list. It’s a bit like what you'd find in https://www.blueberry-ai.com/blog/12-best-digital-asset-management-software-for-photographers, where you link assets (like images) to certain categories or users. This method can help keep everything in sync and automated, making tracking much easier.