cut and copy automatically onto another worksheet

[MINAL ZUNKE]

Hi
Experts
I am working on excel sheet to make a daily production report. In my
worksheet, I have 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, it
should get copied automatically to another worksheet 3.

Any workable suggestion will be greatly accepted.
Thanking in anticipation!!!

 

[MINAL ZUNKE]

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!!!

 

[John Vinson]

Hi
Experts
I am working on excel sheet to make a daily production report. In my
worksheet, I have 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, it
should get copied automatically to another worksheet 3.

Any workable suggestion will be greatly accepted.
Thanking in anticipation!!!

I would suggest that you ask this Excel question in an Excel
newsgroup; this newsgroup is for a different program, Microsoft
Access.

Please scroll down the list of newsgroups to find one for Excel.

John W. Vinson[MVP]