Removing Rows from one spreadsheet to another

Hello,

I posted a forum about this before (http://www.excelforum.com/excel-prog...-new-post.html), and the code I was using worked for a while, but now i'm running into problems.

Please Login or Register  to view this content.

This code is working partially: It pastes the rows into the History sheet, but it doesn't always remove them from the Current sheet. I'm not sure if it has to do with being in tables or not. I also have another forum (http://www.excelforum.com/excel-prog...76#post3261576) about how my tables aren't expanding with new data.

The workbook is posted.
Any ideas?

Hello,

So, that code doesn't insert headers on the history sheet like it originally did,
and when I try to change "with ws" to "with ms" (thinking that was the mistake) it doesn't remove the selected row off the current sheet. Any ideas?

Thanks

Thank you!

hi tehneXus,

think you could help me out? http://www.excelforum.com/excel-prog...html?p=3300489

I'm still using the same code from this thread. but now i'm running into errors.

i'm dealing with frozen panes and its not working the same