Dear all,
As I am a total newbie, I ask for your understanding. I am not even sure if my problem can be solved using excel.
I must maintain a list of certain mechanical components that are installed in three types of machines, scattered around different locations in the country.
The problem is that these components are changing between machines from time to time, for maintenance, repairs etc, so, somehow, I must follow what happens.
What device was uninstalled from what machine, where did it go and why, where did it return, on what day etc.
Keep in mind that these devices are, let's say the same on every type of machine, but with a unique serial number of course. Some can be installed to more than one type of machine.
I am thinking of creating XXXX groups and then interconnecting their contents.
Groups:
Location
Machines
Devices
Please, anybody to point out which direction to look into?
I am not asking for a final solution, just some guidance.
The excel version I will be using to create this will be excel 2016 but backwards compatibility is required.
Thank you very much in advance,
Metsam
As I am a total newbie, I ask for your understanding. I am not even sure if my problem can be solved using excel.
I must maintain a list of certain mechanical components that are installed in three types of machines, scattered around different locations in the country.
The problem is that these components are changing between machines from time to time, for maintenance, repairs etc, so, somehow, I must follow what happens.
What device was uninstalled from what machine, where did it go and why, where did it return, on what day etc.
Keep in mind that these devices are, let's say the same on every type of machine, but with a unique serial number of course. Some can be installed to more than one type of machine.
I am thinking of creating XXXX groups and then interconnecting their contents.
Groups:
Location
Machines
Type of machine
Devices
type of device
After that, I have to find a way to connect them, maybe be able to select the machine, location etc from a drop down list etc.
Please, anybody to point out which direction to look into?
I am not asking for a final solution, just some guidance.
The excel version I will be using to create this will be excel 2016 but backwards compatibility is required.
Thank you very much in advance,
Metsam
