Hello,
would require help on the key code for the following scenario ( a link which has similar code would also help)
1. copy /append all rows to FileB from FileA
2. Name of worksheets in the source and destination files Is same
3. Hence the data should be copied to its corresponding / matching worksheet
Ex: Both FileA & File B will have "Mywksht1", "Mywksht2", "Mywksht3". Data from Mywksht1 from FileA should be copied to Mywksht1 in FileB and so on..
Thanks.
Maybe:
Please Login or Register to view this content.
Slight alteration to John's code incase you need to add the data to the next available row of each sheet in FileB.
Please Login or Register to view this content.
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]
Thanks a Ton ! this cannot be any simpler
Please mark this thread as solved - Thread Tools -> Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks