VBA Cut Copy Issue

Hi everyone,

Here is some background information on this issue:

I am trying to create a daily report. In doing this I want to be able to pull external data into a sheet, specifically a tab called "Datapaste 2." From here I have a Macro that deletes the top row of data (as it is simply a header I don't need), then the Macro moves my data to another tab called "Data." The problem that I run into, is that the macro will simply copy over the previous days data when I need it to be pasted at the bottom of whatever data is in the "Data" tab, so that I can start collecting historical data. I would need the data I am pasting over to be placed at the bottom of whatever previous data there is and starting in column B, not A. I have the Macro assigned to a form control button named, "Click me." Not sure if that info is needed.

We were able to figure out how to complete the above; however, rather than simply copying the date from "Datapaste 2" to the bottom of the previous data that has been pasted in "Data" I would like to do a cut and copy, or have a way that after the data has been pasted and moved from "Datapaste 2" to "Data" it will delete and leave everything blank from row 10 down in "Datapaste 2." (Still leaving the data that has run through the Macro in the "Data" tab of course.

Essentially I want to paste the data I have imported from another file into cell A10 of the "Datapaste 2" tab, then click my form button, which will delete row A10, and then move that data to the bottom of any previous data in the "Data" tab. From here I would like excel to go back to the "Datapaste 2" tab and delete all of the contents from row 10 down.

Here is a copy of the code:

Please Login or Register  to view this content.

Thanks!