See attached example.
I am looking to automate excel to get it to produce a worksheet per room so an engineer can take a printout of the sheet when they go client site to do maintenance visits.
Sheet 1 is the main (master) equipment list for all rooms.
Sheet 2 is a list of things that the engineer needs to do as part of their visit (dependant on kit type).
Sheet 3 + 4 are individual sheet (per room) that are automatically produced and formated so that they can be printed and used by the engineer.
Format of sheet 1 will be [url removed, login to view] number of rooms and amount of client equipment will vary.
Can you provide automate the above as needed?