Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
collating Data
Hi I would be grateful if someone could help me with this problem please... I cuurently have a workbook with the sheets designed as a diary (each sheet being one date. On each row of a partiuclar sheet I enter different jobs under various headings in the columns One of the columns is for a persons payroll number and is unique to that person. What i am trying to do is to group / collate all the entries for one person onto another worksheet so at the end of the month it will show all the jobs that person has done for the month. I have tried (very unsuccesfully!!) to do this myself so would really appriciate some advice or help from the Experts out there. If the explanation of what i am trying to do is not clear, please feel free to contact me. Many thanks Paul -- Paul Cooke ------------------------------------------------------------------------ Paul Cooke's Profile: http://www.excelforum.com/member.php...o&userid=29268 View this thread: http://www.excelforum.com/showthread...hreadid=490774 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |