MS Excel - Worksheet creation

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?

Taidot: tiedonlouhinta, Excel

Näytä lisää: kit creation, master excel, excel automate, creation excel, type excel sheet, excel list example, format list excel, master excel sheet, example list excel, excel master sheet, looking can per excel, number creation, example excel list, excel master, produce excel sheet, creation sheet excel, excel creation, excel list creation, excel sheet creation, vba import excel ms project schedule, transfer data ms excel ms word ole technology, produce excel, import ms excel ms sql, excel worksheet, excel ms word programing vba

Tietoa työnantajasta:
( 15 arvostelua ) READING, United Kingdom

Projektin tunnus: #4269717