ramkiller1
New member
- Joined
- Jul 23, 2014
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Good Day,
I would like to make an excel spreadsheet with Equipment Inventory that some how links with each other. For example, I would like :
Sheet1 to have some sort of searching mechanism (probably a pivot table) that would list for me all of a certain criteria I ask for like all Pcs without keyboards or all in a certain location.
Sheet2 to have all data of each Pc like location of the pc, model, manufacturer, ram, cpu.
Sheet3 to have all screens data with location, model, manufacturer, and size but then some how linked to Sheet2 so that when I look for a PC and I find one, I would also get the screen the PC is connected to.
Sheet4 to have all data of UPS with location, model, manufacturer, and watts then some how linked to Sheet2 so that when I select a PC, I would be able to see what UPS it is connected to .
Is something like this possible?
Thanks,
Dayne
I would like to make an excel spreadsheet with Equipment Inventory that some how links with each other. For example, I would like :
Sheet1 to have some sort of searching mechanism (probably a pivot table) that would list for me all of a certain criteria I ask for like all Pcs without keyboards or all in a certain location.
Sheet2 to have all data of each Pc like location of the pc, model, manufacturer, ram, cpu.
Sheet3 to have all screens data with location, model, manufacturer, and size but then some how linked to Sheet2 so that when I look for a PC and I find one, I would also get the screen the PC is connected to.
Sheet4 to have all data of UPS with location, model, manufacturer, and watts then some how linked to Sheet2 so that when I select a PC, I would be able to see what UPS it is connected to .
Is something like this possible?
Thanks,
Dayne