Hello,

I have a worksheet where we store devices handovers in our company. (handovers.xlsx)
I have a list where can find all devices. (all_device.xlsx)

When I write a ID in first column of handovers.xlsx the macro need to find this ID in all_devices.xlsx. If the macro found is need to copy data from the other column (serial number, name) to the handovers.xlsx.
But sometimes in all_devices.xlsx to one ID have more than one row. In this case I need to list the rows in a listbox, and after the macro need to copy the selected line (in listbox) other coulmns (serial number, name etc...)

Anyone could help in this to me?

Thanks very much,
draki