I work for a mining company, and I need to be able to easily check if a piece
of equipment requires maintenance/repairs of not. I have created a workbook
for technicians to use when servicing these pieces of equipment. Once they
have serviced the equipment, they enter (using 'ticks' and crosses') what
status the different parts of the equipment are in. I need to be able to,
simply by looking at the first spreadsheet, whether or not a cross has been
placed in any part of the servicing sheet. Is there a way that I can link the
cells to a cell on the first spread sheet so that whenever a cross is placed,
it is displayed on the first spreadsheet.
Any assistants would be greatly appreciated. Thank you.