Hi

What do you use to determine what case goes where? Ie. is there a cell in
each row that tells you to whom that case is assigned? The easiest would be
to name each sheet with that bit of information and use the cell.value in a
loop.

/Sune

"hipul" wrote:

Hi,

I have a team of 10 people who work on 1 single work book, all of them
have a seperate sheet for thenselves, what i do manually at this point
in time is as and when required i cut+paste case number and details
on the same line from the main sheet to the individual sheet. i would
like to write a macro so this can be done by a press of a button.
Once the details are cut pasted they should be erased from the main
sheet so that the person who tries to pull cases from the main sheet
will get cases after that. I am currently looking at approximately 10
cases to be transered at one shot.

Hope this does not sound very confusing.

Hipul