Automatically move entire rows from one Worksheet into another Worksheet in the same Workbook

[joeyjay]

I have a Task List Workbook (with 2 Worksheets)

Worksheet 1 will be just for Open Task Items. Worksheet 2 will be just for Closed Items.

Worksheet 1 will consist of rows of Open Items.

The last column for each row on Worksheet 1 will either be a checkbox (for task completed) or a cell that we type a "completed date" into.

Once the last column cell is checked as completed or the cell is populated with a complete date, is there a way to have that be the trigger for the entire row to transfer over (be cut) from Worksheet to Worksheet 2 of the same Workbook?

Again, Worksheet 1 will be just for Open Task Items and Worksheet 2 will be just for Closed Items.

Thank you for your help.

 

[My Aswer Is This]

I think you should tell us what your wanting to do. Trying to read this old posting and attempt to understand what you want can be difficult.

So I input this code and it is running with no errors I'm assuming because I get nothing saying there is an error. However nothing is happening when I input a date into the cell that I am using as my rngTrigger. Any help would be greatly appreciated.

 

[hiker95]

So I input this code and it is running with no errors I'm assuming because I get nothing saying there is an error. However nothing is happening when I input a date into the cell that I am using as my rngTrigger. Any help would be greatly appreciated.

jthimes,

Welcome to the MrExcel forum.


We can not tell where your raw data is located, sheet name(s), cells, cell formatting, cell formulae, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, cell formulae, rows, columns.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


If you are not able to provide screenshots, then:

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[jthimes]

[TABLE="width: 1510"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 7"]Below is an example of my workbook. I am wanting when a death date is entered in either the pasture or feedyard for it to move said row to sheet two with all the information in that row. I have sheet two cells the exact same as sheet one which is shown below



Processing[/TD]
[TD] [/TD]
[TD="colspan: 5"]Pasture[/TD]
[TD] [/TD]
[TD="colspan: 6"]Feedyard[/TD]
[TD] [/TD]
[TD] Total Invoiced Amount [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Owner[/TD]
[TD]Type[/TD]
[TD]QTY.[/TD]
[TD]Tag #[/TD]
[TD]Today's Date[/TD]
[TD] Processing Cost [/TD]
[TD]Invoice #[/TD]
[TD] [/TD]
[TD]In Date Pasture[/TD]
[TD] Pasture Feed Cost [/TD]
[TD]Sick Cost (Pasture)[/TD]
[TD]Death Date[/TD]
[TD]Days Fed (Pasture)[/TD]
[TD] [/TD]
[TD]In Date Feedyard[/TD]
[TD] Feedyard Feed Cost [/TD]
[TD] Feedyard Sick Cost [/TD]
[TD]Death Date[/TD]
[TD]Days Fed (Feedyard)[/TD]
[TD]Out Date[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]151[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23100[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]January 1, 2001[/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]152[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23101[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]153[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23102[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]October 1, 2015[/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]154[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23103[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]155[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23104[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]156[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23105[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]157[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23106[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]158[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23107[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]159[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23108[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]160[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23109[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[hiker95]

Below is an example of my workbook. I am wanting when a death date is entered in either the pasture or feedyard for it to move said row to sheet two with all the information in that row. I have sheet two cells the exact same as sheet one which is shown below

jthimes,

When I attempted to copy your flat text display, and, paste it into a worksheet, the formatting was not correct.


You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[jthimes]

here is the link.

https://www.dropbox.com/sh/jh14qt0gege04sg/AADW-AYcZAv5pYGqbddZSQWKa?dl=0

 

[hiker95]

jthimes,

When I clicked on download, I got the following message:

What do you want to do with the Excel.zip?


I have had problems in the past when attempting to download a zipped file, or, an Excel file with macros, with the xlsm file extension.

Please try again on dropbox, withput zipping the workbook/worksheet(s), or, by including a smaller version of the workbook/worksheet(s).

 

[jthimes]

Try this one. I am using 2013 but saved as a 97-2003 workbook

https://www.dropbox.com/s/9tpvrgs08evq07s/Wilson.xls?dl=0

 

[hiker95]

Try this one. I am using 2013 but saved as a 97-2003 workbook

https://www.dropbox.com/s/9tpvrgs08evq07s/Wilson.xls?dl=0

jthimes,

Thanks for the workbook/worksheets.

So that we can get it right on the first try, can we have another workbook, with worksheet Sheet2 manually completed by you for the results that you are looking for?

 

[jthimes]

I am wanting if a death date is entered for that row to copy all information for that row on sheet1 to sheet2 and delete it from sheet1. If no death date is entered then it stays on sheet1.

https://www.dropbox.com/s/8p8mdyyixsktmmb/Wilson2.xls?dl=0

Thanks for all your help

 

[hiker95]

jthimes,

So that we can get it right on the first try, can we have another workbook, with worksheet Sheet2 manually completed by you for the results that you are looking for?