Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table

Good morning!

I am a total noob to VBA creation. I have been looking through the forums for scraps of code to apply to my workbook, but it is not performing as desired.

I would like completed data rows entered into the "EnterTime" worksheet to be moved to the "Review" Worksheet when clicking on the "Add Records" button, without deleting formatting or rows from the "EnterTime" record (I just want the text moved and the "EnterTime" worksheet cleared). Currently, the macro is pasting blank rows as well as completed rows to the "Review Tab".

I would then like the data to be moved, one record at a time from "Review" worksheet to "Data" worksheet after the HR person has entered the Pay Status (column J), which can be U or P, and their initials. It could be multiple people that enter initials. Currently, the data is not moved when the information is entered.

While I appreciate how thorough everyone is in their posts and how helpful they are with providing information, I would also like a critique or explanation as to why this isn't working. I really want to get my flight wings.

Thanks so much!

Jan

Good Morning, or afternoon, jaslake

I think I missed something with the changes made in data columns. I don't see a workbook attached to review it. I applied the codes, and it doesn't seem to reflect the changes made to the data columns;

"Notice I've changed your Formulas in Sheet Data Columns K, L, M and N to eliminate the VLookUps. The Code appears to run much quicker with this change and to do as you described...let me know of issues."

Did I miss something?

I'm fumbling through the code right now. Thanks so much!

Hi Jaslake,

I used the spreadsheet provided and it works fabulously! Thanks so much! Is there a code I can add that will remove the records from the "Review" tab once they're transfered to the "Data" tab?

Thanks!

Jan