Append data from WS2 to WS1
I'm pretty new with using VBA overall and I was hoping to get some guidance on vba code.
I have a workbook called Student with 2 worksheets, (WS1 - "Roster"), (WS2 - "New")
On a daily basis, data gets entered in WS2 and needs to get APPENDED to the bottom of the WS1.
I have this macro but i'm not sure why it gives me a runtime error:
Please Login or Register to view this content.
PLEASE HELP
Any input is greatly appreciated!
Last edited by arlu1201; 06-13-2012 at 11:13 AM. Reason: Code tags
It'd be easier to check, test and correct with a sample of the workbook.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try thisPlease Login or Register to view this content.
Last edited by arlu1201; 06-13-2012 at 11:34 AM. Reason: Changes to code
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
@Arlette: my impression was that data was added to the New workbook and appended to the Roster.
Thanks TMS. Sheet confusionGot it corrected.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks