I have written a very basic macro to copy various pieces of data from one sheet to another. Howvever each time I run the macro it pastes any new information onto the same line.
I would like the macro to be able to copy the relevant information but post to a new line each time.
Any help would be appreciated.
Thanks.
If any more information is needed please ask.
Last edited by wjt1987; 01-11-2012 at 09:08 AM.
Please Login or Register to view this content.
It will be good if you attach the sample file along with the code. And you can also state which fields need to be copied where, so we can help you easily.
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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks