Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying / Collating Data ....
Hi I would be grateful if someone could help me with this proble please... I cuurently have a workbook with the sheets designed as a diary (eac sheet being one date. On each row of a partiuclar sheet I enter different jobs under variou headings in the columns One of the columns is for a persons payroll number and is unique t that person. What i am trying to do is to group / collate all the entries for on person onto another worksheet so at the end of the month it will sho all the jobs that person has done for the month. I have tried (very unsuccesfully!!) to do this myself so would reall appriciate some advice or help from the Experts out there. If the explanation of what i am trying to do is not clear, please fee free to contact me. Many thanks Pau -- Paul Cook ----------------------------------------------------------------------- Paul Cooke's Profile: http://www.excelforum.com/member.php...fo&userid=2926 View this thread: http://www.excelforum.com/showthread.php?threadid=49107 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying / Collating Data ....
Paul,
Take a look at "array formulas" in which you can sum and count unsorted data across sheets, this may be an option for you. An array formula is entered into (in this case your summary sheet) using [Ctrl]+[Shift]+[Enter] keys and these are very powerful. In particular look at "SumIf" which can also be structured as "=Sum(If(..." if you need to nest multiple criteria. Also look at the "VLookUp" formula. I think you can accomplish what you need with very little if any VBA coding and just use formulas. HTH. "Paul Cooke" wrote: 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=491079 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling/Collating Data | Excel Worksheet Functions | |||
Collating Data from Many Worksheets Within a Workbook | Excel Discussion (Misc queries) | |||
collating data | Excel Discussion (Misc queries) | |||
collating Data | Excel Discussion (Misc queries) | |||
Collating data from one worksheet to another | Excel Programming |