One play to try ..

Assume source table is in Sheet1, cols A to W, data from row2 down
(Key column is col F, key input in col F is: C)

In an empty col to the right, say col X

Put in X2: =IF(F2="","",IF(F2="C",ROW(),""))

Copy X2 down to say, X100 to cover the max expected data range for the
source table (can copy down ahead of expected data input)

(Leave X1 empty)

In Sheet3
------
Paste the same col headers into A1:W1

Put in A2:

=IF(ISERROR(SMALL(Sheet1!$X:$X,ROWS($A$1:A1))),"", INDEX(Sheet1!A:A,MATCH(SMA
LL(Sheet1!$X:$X,ROWS($A$1:A1)),Sheet1!$X:$X,0)))

Copy A2 across to W2, fill down to W100
(cover the same range as was done in col X in Sheet1)

Format the cols as per the source cols in Sheet1

Sheet3 will return the desired results, i.e. only the rows from the source
table where the status input in col F in Sheet1 is: C, all bunched neatly at
the top

Adapt to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"MINAL ZUNKE" wrote in message
...
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!!!