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

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