• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

copy text from one sheet to another using macro [SOLVED]

S

sdey73

New Member
hi friends,


need your help, what i want is in sheet1 only one row is there where user will fill, and end of the row a command button is there which is clicked by the user after complete the details at that row. when the user will press that button the entire data of the row will be copied to sheet2 at the end. here is the link of an example file: https://www.dropbox.com/s/4psf0lobvwiuibg/COPY%20TEXT.xlsx. i have already searched in custom search but not found.


regards

sudipta
 
Sudipta


Have a look at:

https://www.dropbox.com/s/vzg8blh73qsvugw/COPY%20TEXT.xlsm
 
hi hui,


thanks again for your help, but need one more help on this topic, can't we get the "SR.NO" serialy except "x" on sheet2?


https://www.dropbox.com/s/vzg8blh73qsvugw/COPY%20TEXT.xlsm


regards

sudipta
 
Hi sudipta,


kindly try the below link


https://www.dropbox.com/s/by5g79vvbh0nw6j/copyonesheetoanothersheetmacro.xlsx
 
HI Webmax,


I am sure.. you have done a great job.. welcome to the VBA Cruel world..


allow me to start cruelty.. .XLSX file not able to store your VBA code.. so always save XLSM or XLSB format.. :)


Regards,

Deb
 
hi sudipta


kindly use the below link which will support all excel files.


https://www.dropbox.com/s/4420yiah1sp8zxi/copyonesheetoanothersheetmacro.xls


Thanks deb
 
@webmax thanks a lot, but don't use the word kindly, after all we all are the friends

@Debraj Roy thank you for your support


thanks to both of you


regards

sudipta
 
You must log in or register to reply here.
Back
Top