I need help with a macro which can copy data from one sheet and paste in in another sheet in the next available cell. After doing this it should clear the contents from the source sheet so that it is fresh and ready to be used again.
I want a macro which can copy data from one sheet and paste in in another sheet(5 posts) (4 voices)
Firstly, Welcome to the Chandoo.org Forums
You may want to consider pasting a sample file so we can see the format and assist you better
Refer the Sticky green posts on the main forum page
Import this macro in your file
I can bet that the macro is working fine.. but it will be great pleasure if you can give pemission to all to view / download the sheet.. :)
for posting any file you can go for below sites also..
you can use the below sytax also for display properly your post..
a blockquote code em strong ul ol li. You can also put code in between backtick (Just below ESC) characters.
Updated the link & it is downloadable now.
You must log in to post.