I have the following; -
3 sheet workbook, Sheet 1 called Front Page. Sheet 2 called Home and
sheet 3 called A.
Sheet 1 (Front Page) is just a sheet with instructions. On sheet 2
(Home) is the results of entries made on Sheet 3 (A).
I make the following entries on Sheet 2. A6 to A222 are names which
transfer onto Sheet 3 automatically using =A6 etc going across the
sheet from E7 to IT7.
Sheet 1 B2 to B222 is have a hyperlink to jump to a name on sheet 3
which is
=HYPERLINK("#A!R6C"&MATCH(A6,A!$D$7:$IS$7,0)+3,"ju mp")
On sheet 3 (A) I enter either of the following:- d or hd for holidays
the result going into E1, =SUMPRODUCT(--(E7:E2038="d"))--(--SUMPRODUCT
(--(E7:E2038="HD"))*0.5)
L for lateness going into cell E2, =SUMPRODUCT(--(E7:E2038="L"))
1 for absence going into cell E3, =SUMPRODUCT(--(E7:E2037=1),--
(E8:E2038<1),--($A7:$A2037=TODAY()-365)) which counts each 1 and
blocks of 1.
Au or AD going into cell E4, for full day or half day authorised,
=SUMPRODUCT(--(E7:E2038="AU"))--(--SUMPRODUCT(--(E7:E2038="AD"))*0.5)
All this works great but, as with all good things someone has come up
with something new to add.
Along with the 1 I now need to enter either 1 p or 1 up. The result of
1 still needs to do the same as I have now. The result of p needs to
go into E5, the result of up into E6.
I have been told this can be done using a macro and entering something
like 1,p.
Can anyone give me any help with this please. I am at a loss.

Bryan.