Morning all.
I need advice on where to start with a project/idea I have had.
I have an excel document which is a training matrix, which contains all the staff details for over 300 staff (that number is growing continuously). Each of the staff have a clock number which is in cell B8 downwards. Columns C:G also contain information such as start date, first name, last name, department and shift.
I need to produce "timesheets". I have the layout in my head, but I need to import the information into the new document from the matrix that I want. The Matrix is managed by the HR Department, so should be the gospel as far as accuracy of staff.
In order to import, I won't know the end point of the document. I could just go overkill, but I am thinking there may be a better way.
How should I be thinking of this? Macro? Easier solution?
Basically, I want the time sheet to look into the matrix and list all the information I need that relates to some exacting details.
So in cell A1 I have "Production" and in cell B1 I have "Nights"
In cell A3 downwards, I want to list all the clock numbers of all the operatives who are listed as being on Production Nights.
Is this even possible?
I need advice on where to start with a project/idea I have had.
I have an excel document which is a training matrix, which contains all the staff details for over 300 staff (that number is growing continuously). Each of the staff have a clock number which is in cell B8 downwards. Columns C:G also contain information such as start date, first name, last name, department and shift.
I need to produce "timesheets". I have the layout in my head, but I need to import the information into the new document from the matrix that I want. The Matrix is managed by the HR Department, so should be the gospel as far as accuracy of staff.
In order to import, I won't know the end point of the document. I could just go overkill, but I am thinking there may be a better way.
How should I be thinking of this? Macro? Easier solution?
Basically, I want the time sheet to look into the matrix and list all the information I need that relates to some exacting details.
So in cell A1 I have "Production" and in cell B1 I have "Nights"
In cell A3 downwards, I want to list all the clock numbers of all the operatives who are listed as being on Production Nights.
Is this even possible?
