Hello:
I have excel workbook which will have weekly payroll Data in Sheet1, Cell A3:N22
I need a VB Macro to move these data every week in Sheet2, starting in Cell A3.
Basically would need to paste the data in the next blank row in sheet2.
(Ist Batch of data with start A3:N22 in sheet2, 2nd Batch of data will start at A23)
Please let me know if any questions.
Thank you
Riz Momin
Last edited by rizmomin; 05-27-2013 at 09:26 PM.
Do you need a Command Button that would take all of the information from A3 to N3 looking in the rest of the rows if information is there and to copy and paste them on the next available row in Sheet2?
Or do you need to have it on Open Workbook?
If you go with a Command Button try this:
Add this to your Sheet1
Please Login or Register to view this content.
Last edited by Excelnoub; 05-27-2013 at 09:15 PM.
Hi Excelnoub:
This works great.
Thank you so much for your great help.
Riz Momin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks