Hi,
I have searched the below codes on this forum and modified a little. It should have been perfect code for my purpose except that if there are no more data from row 3 in the source sheet ["BANK ENTRIES"] and the user (by mistake) clicks again the button to run the macro, the second header [row 2] will be moved to the other sheet ["Bank-Cleared"] and if the user clicks the button further, the first header [row 1] will be moved as well. The bad thing is that, my button is in row 1 which will be deleted and pasted to the other sheet ["Bank-Cleared"]. Kindly help.
Please Login or Register to view this content.
Bookmarks