How to Transfer Data from one Sheet to another based on Status

[Juan_mc14]

Good Afternoon,

I have the following data on Sheet1:

Title Runs Total Runs Runs Left Status

ASSAULT ON PRECINCT 3 3 0 Completed



BACK TO THE FUTURE II 3 2 1 Incomplete



BACK TO THE FUTURE III 3 4 -1 Extra Run



And I have two different tabs. One is under the name “Completed” and the other one under the name “Extra Run”. What I want to do is copy all the “Completed” and “Extra Run” Titles to the respective tab and that once a title reaches the status of “completed” or “extra run” the information of that title will automatically be copied to the “Completed” or “Extra Run” tab. I have the following formula under status =IF(O10=0,"Completed",IF(O10>0,"Incomplete",IF(O10<0,"Extra Run"))) to know when a title is completed or have any extra run. i will be updating the workbook weekly.



Thank you for the help

JP

 

[PCosta87]

Hi,

Welcome to the forum

Here you go (please refer to attachment).

The button will copy all rows where status is different from "Incomplete" to their respective sheets, below the last one already there.
There is also a Worksheet_Change event in place in the "List" sheet that copies the data over to the respective sheet once you change the "Total Runs" (column "C").

Hope this helps.

 

[Juan_mc14]

Hi,

Welcome to the forum

Here you go (please refer to attachment).

The button will copy all rows where status is different from "Incomplete" to their respective sheets, below the last one already there.
There is also a Worksheet_Change event in place in the "List" sheet that copies the data over to the respective sheet once you change the "Total Runs" (column "C").

Hope this helps.

Thank you so much! I think this will do. I will test it tomorrow

 

[PCosta87]

Thank you so much! I think this will do. I will test it tomorrow

Don't mention it