G
Glennyboy
Hi all, I am looking for some advice on where to start. I am trying t
produce a monthly report from an excel sheet. What I have is:
Clients in a columb to the left, activity type in a row across the to
(matrix). As I complete a certain activity I fill in the appropriat
cell with a date.
What I would like to do is produce a sheet that tells me which client
were seen on a given month and who received what. I know that I coul
filter but I was wondering if there was a function that would
recognise the month, identify the client and then produce a list a
there will be more that on
produce a monthly report from an excel sheet. What I have is:
Clients in a columb to the left, activity type in a row across the to
(matrix). As I complete a certain activity I fill in the appropriat
cell with a date.
What I would like to do is produce a sheet that tells me which client
were seen on a given month and who received what. I know that I coul
filter but I was wondering if there was a function that would
recognise the month, identify the client and then produce a list a
there will be more that on