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
Bookmarks