Need a button to transfer data to another sheets

[proficient]

Hi all,

I have a question regarding code, what I want to do is that I need a button as I mentioned in subject to move a data (which I put manually in a sheet named 1, and want that when I will press the button the data I put automatically transfer from 1 to sheet 2, both sheet 1 and 2 formats are same, please help!

 

[mole999]

the button is easy. add an auto shape, right click it and use the add macro/eventm as for the moving data there are many routines all over the place, just have to know what is best for your needs

 

[My Aswer Is This]

We need to know where on sheet1 the data is and where on sheet2 you want it put

 

[kumar lama]

I don't understand what is the reason that you want move date? or if you just want move data for nothing, you just can use formula instead of button. formula will automatic update your data in next Sheet or Next Workbook.

 

[proficient]

We need to know where on sheet1 the data is and where on sheet2 you want it put

There is a slight change in transfer, now I have 2 cell, first is TODAY and another is TOTAL, I put value(s) in TODAY on daily basis and want to excel add it in TOTAL cell automatically (means when I click the ADD button {which you guys are supposed to provide me} it would add in total and clear the today's cell) HOPE ITS CLEAR