'save' 'clear' command button in excel

[ganeshm]

test file.xlsx

http://www.ozgrid.com/forum/showthread.php?t=176490&p=654855&posted=1#post654855


Kindly help me to solve command button issues. I would like to input values in the sheet1 and then save, the data entered in sheet 1 should directly get saved in sheet 2 row by row.

 

[koi]

hi,


welcome to the forum,


maybe this is what you want (it is working perfectly, thanks to luke)

http://chandoo.org/forums/topic/macro-to-copy-paste-value-from-sheet1-to-sheet2-in-empty-cell


and you have to be able to have at least a bit of macro knowledge

 

[ganeshm]

Dear koi and Luke,


Thank you for the inputs.


http://www.ozgrid.com/forum/showthread.php?t=176490&p=655074#post655074


With the inputs given, I have applied formula for Save & Clear command buttons. The issue here is sheet1 has these command buttons and with formula, when value is entered and "save" is pressed - sheet2 has to document the values. I was able to do for only one row in this excel book. Kindly guide me to apply for other rows in sheet2.


Thank you.

 

[sgmpatnaik]

@ganeshm


Hi


it is better to upload a sample file as per your requirement


actually what you want to achieve when you enter the data in Sheet1 and when you press the Command button for save then the sheet1 data to copy and paste in the sheet2 is this correct then please download the below file


https://dl.dropbox.com/u/75654703/Copy%20Sheet1%20and%20Paste%20in%20Sheet2%20and%20Clear.xlsm


hope it will solve your problem other wise please inform us


Thanks


SP

 

[ganeshm]

@ sgmpatnaik...


I believe i missed out something in VB. Its working...

thank you.


ganeshm