In order to track service/repair details of some machines, I've put a database, named db1, in Sheet2, with twelve fields (e.g. ID number, machine_description, brand, model, duration_of_service, cost etc.).
When I enter the ID number of a machine in Sheet1, cell A1, I want to have the values of selected fields (say 6 fields) of db1. So, Sheet1 is going to contain cell A1 with ID number of the machine, 6 columns filled with data from corresponding fields of db1 and such rows as the services/repairs count for given ID number.
Thanks
Bookmarks