cut and paste to different worksheet

thnx max for your efforts
cheers

"MINAL ZUNKE" wrote:

> Hi
> > Experts
> > I am working on excel sheet to make a daily production report. In my
> > worksheet, there are 300 rows selected for a week and column from A to W. Column F is named as "STATUS".
> When a particular job finishes, person on the section puts C (C means
> Completed) in the column F. What I am after is as soon as column F (Status)
> goes C, then information for that job from column A to column W should get
> copied automatically to another worksheet 3.
>
> consider in one day 10 jobs gets completed onto a section then 10 jobs
> infomation from column A to column W should get copied automatically onto
> worksheet 3 as soon as status (column F) gets updated to "C".
>
> Any workable suggestion will be greatly accepted.
> Thanking in anticipation!!!

You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"MINAL ZUNKE" <MINALZUNKE@discussions.microsoft.com> wrote in message
news:50D2DCB7-BCCE-4ACB-8B43-70856B5F5A8A@microsoft.com...
> thnx max for your efforts
> cheers