Simple Cut/Paste VB

[BadFish523]

Hello,

I think this is a simple VBA but I could not figure it out. I have two sheets one to contain live data and another to archive older data from the live sheet. The sheet names are Data and Archive. I want to create a button that when pressed will cut the first 900 rows from Data and paste them into the first empty row in Archive. If it helps any both sheets have tables. The table names are Data and Archive as well. So simply I would like to take rows 2 through 902 from the table Data and put them at the bottom of the table Archive. Does this make sense?

Thanks,
BadFish

 

[Marc L]

take rows 2 through 902

Hi, so 901 rows and not 900 …​