Advice on where to start

[GazNicki]

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?

 

[oldbrewer]

name	shift
alan	early
bill	late
colin	night					shift	night
dave	late
ed	night					Count of name
fred	night					name	Total
george	shift					tom	1
harry	early					fred	1
ian	late					colin	1
joe	night					ed	1
kevin	late					joe	1
larry	night					larry	1
mike	night					mike	1
nick	shift					quentin	1
oscar	early					steve	1
pete	late					Grand Total	9
quentin	night
richard	late
steve	night
tom	night
				a simple pivot table lists all staff on night shift
				whenever you update the master list
				be sure to update the pivot table

<colgroup><col span="6"><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[oldbrewer]

name	shift	clock
alan	early	3119
bill	late	3140
colin	night	3161				shift	night
dave	late	3182
ed	night	3203				Count of clock
fred	night	3224				clock	Total
george	shift	3245				3161	1
harry	early	3266				3203	1
ian	late	3287				3224	1
joe	night	3308				3308	1
kevin	late	3329				3350	1
larry	night	3350				3371	1
mike	night	3371				3455	1
nick	shift	3392				3497	1
oscar	early	3413				3518	1
pete	late	3434				Grand Total	9
quentin	night	3455
richard	late	3476
steve	night	3497
tom	night	3518
						this time list of clock numbers
						easy to put employee name next to clock number

<colgroup><col span="6"><col><col><col span="5"></colgroup><tbody>
</tbody>

 

[GazNicki]

I need the new sheet to ideally auto-update, so that it can be printed by people with relative ease.

I will have a look at the pivot table, but may need a more indepth and automated solution if one would exist.