P
Peter Hannan
Hi all,
In my job attendance is recorded each day for everybody. Code letters
are assigned for the different categories. eg P for present, L for on
leave etc.
The spreadsheet is setup so that names and details are down the left and
the day number (ie 1,2,3,4,5...........) are across the top. I have a
cell that contains the month and another for the year.
I need to compare today's date with those day values across the top in
conjunction with the month and year obviously and from that provide a
list of the names with the corresponding marks next to their name. The
names need to be divided up into their relevant groups.
Their are 11 categories, roughly 100 names(with the possibility to
expand to 500)
Can you help me? The information can be filtered out manually with the
auto filter option, however I am a big fan of automation.
If anyone is interested I have produced a macro to capitalise all the
letters on a spreadsheet. Just in case you realise you have typed half
of it and need to change it.
please email response to
(e-mail address removed)
In my job attendance is recorded each day for everybody. Code letters
are assigned for the different categories. eg P for present, L for on
leave etc.
The spreadsheet is setup so that names and details are down the left and
the day number (ie 1,2,3,4,5...........) are across the top. I have a
cell that contains the month and another for the year.
I need to compare today's date with those day values across the top in
conjunction with the month and year obviously and from that provide a
list of the names with the corresponding marks next to their name. The
names need to be divided up into their relevant groups.
Their are 11 categories, roughly 100 names(with the possibility to
expand to 500)
Can you help me? The information can be filtered out manually with the
auto filter option, however I am a big fan of automation.
If anyone is interested I have produced a macro to capitalise all the
letters on a spreadsheet. Just in case you realise you have typed half
of it and need to change it.
please email response to
(e-mail address removed)