Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill an individual report with values from a team report?
Hi, I have an attendance database, there is a sheet i've created, a Drop Refference table, which shows the persons name, there in days, late days, overtime, and sick days, and from sick days a sick percentage, i did this through COUNTIF statements, pointing them at the attendance tab. I want to build an Individual Report which reports on the people individually, so a user will click a button which will open a input box where they will put the user name they want to report on in the format of; 'J Smith' and then the cells in the new report will point towards the cells for that person but in the Drop Refference table. So its exactly the same values as the Drop Refference but the Individual Report will just show one person. Can anyone help? The only way i think of doing it is a load of IF statements! Thanks! -- alymcmorland ------------------------------------------------------------------------ alymcmorland's Profile: http://www.excelforum.com/member.php...o&userid=27652 View this thread: http://www.excelforum.com/showthread...hreadid=475361 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill an individual report with values from a team report?
If you want to sum on two or more criteria you can use sumproduct
=Sumproduct(--(A1:A100="John"),B1:B100) where column B holds the sick days as an example. You then replace John with a reference to the cell where the name John will Appear =Sumproduct(--(Data!A1:A100=F9),Data!B1:B100) -- Regards, Tom Ogilvy "alymcmorland" wrote in message ... Hi, I have an attendance database, there is a sheet i've created, a Drop Refference table, which shows the persons name, there in days, late days, overtime, and sick days, and from sick days a sick percentage, i did this through COUNTIF statements, pointing them at the attendance tab. I want to build an Individual Report which reports on the people individually, so a user will click a button which will open a input box where they will put the user name they want to report on in the format of; 'J Smith' and then the cells in the new report will point towards the cells for that person but in the Drop Refference table. So its exactly the same values as the Drop Refference but the Individual Report will just show one person. Can anyone help? The only way i think of doing it is a load of IF statements! Thanks! -- alymcmorland ------------------------------------------------------------------------ alymcmorland's Profile: http://www.excelforum.com/member.php...o&userid=27652 View this thread: http://www.excelforum.com/showthread...hreadid=475361 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill an individual report with values from a team report?
Hey could someone help me with this, i understand what your saying Tom but i wouldn't know where to start to turn what you said into code! If i could get an example of one i could do the rest?! -- alymcmorland ------------------------------------------------------------------------ alymcmorland's Profile: http://www.excelforum.com/member.php...o&userid=27652 View this thread: http://www.excelforum.com/showthread...hreadid=475361 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Header in Report Manager Report | Excel Discussion (Misc queries) | |||
Fill-in empty cells from SAP report | Excel Worksheet Functions | |||
Gradebook and Individual Report | Excel Programming |