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 friendly. In the meantime, there is one thing I am stuck on.
I have one sheet for laptops (plus data – RAM, SSD, warranty exp, domain, etc.) One of the columns in the laptop sheet, lists the assigned user (“Employee”). The user is chosen from a dropdown, and the data/choices comes from another sheet that lists employees. The employees list also has a column for laptop and it is supposed to list the laptop assigned to them (“Laptop [Device Name]”).
I would like the laptop column in the employee list to update when the assigned user is entered into the laptop inventory list. OR vice versa, whatever is possible – if either are.
Is this type of connection possible between two sheets?
Thank you for taking the time to read my post.
Sincerely,
Not an Excel Expert
Images:
Laptop Sheet:
Employee Sheet:
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 friendly. In the meantime, there is one thing I am stuck on. I have one sheet for laptops (plus data – RAM, SSD, warranty exp, domain, etc.) One of the columns in the laptop sheet, lists the assigned user (“Employee”). The user is chosen from a dropdown, and the data/choices comes from another sheet that lists employees. The employees list also has a column for laptop and it is supposed to list the laptop assigned to them (“Laptop [Device Name]”). I would like the laptop column in the employee list to update when the assigned user is entered into the laptop inventory list. OR vice versa, whatever is possible – if either are. Is this type of connection possible between two sheets? Thank you for taking the time to read my post. Sincerely,Not an Excel Expert Images:Laptop Sheet:Employee Sheet: Read More