Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Report
Hi all, I am looking for some advice on where to start. I am trying to 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 top (matrix). As I complete a certain activity I fill in the appropriate cell with a date. What I would like to do is produce a sheet that tells me which clients were seen on a given month and who received what. I know that I could filter but I was wondering if there was a function that would recognise the month, identify the client and then produce a list as there will be more that one -- Glennyboy ------------------------------------------------------------------------ Glennyboy's Profile: http://www.excelforum.com/member.php...o&userid=16275 View this thread: http://www.excelforum.com/showthread...hreadid=276806 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL WOULD LIKE TO KNOW HOW TO LINK INVOICES TO A SALES REPORT | Excel Discussion (Misc queries) | |||
Excel Report Using IF Statement? | Excel Discussion (Misc queries) | |||
How do I run a report and identify orders that have been added, d. | Excel Discussion (Misc queries) | |||
Where can I find a template for application report specifications. | Excel Discussion (Misc queries) | |||
Report on data in worksheet? | Excel Worksheet Functions |