How to Save data from a form to another sheet without programming in Excel

In this tutorial you will learn how you can do data entry in one sheet and save it to another sheet without programming in Microsoft Excel
The Developer tab isn't displayed by default, but you can add it to the ribbon.
On the File tab, go to Options - Customize Ribbon.
Under Customize the Ribbon and under Main Tabs, select the Developer check box.
After you show the tab, the Developer tab stays visible, unless you clear the check box or have to reinstall a Microsoft Office program.

[@shelleyhoffman8545]

Thanks for the video provided me with all the info I needed. Only constructive info I can give, I wish the music was lower.

[@cbandaranayakeherath4450]

wonderful work, Thanks

[@topzone2574]

can we do it without save button, what ever user will type it will save or update

[@vijaysalma]

Thanks a lot sir

[@rahuldattu4629]

How to save as a forward manner - like aaa bbb ccc ddd

[@sankarprathap1393]

Supeb bro❤

[@joydipsarkar8748]

sir i need your help regarding data entry .suppose i have some sheets with name a,b,c,d...and when I WILL punch some record IN SHEETS 1 FOR SHEETS A the data will be saved AUTOMATICALLY in seheet a and when punch for b the data will be saved in sheets b ... how can i do this please suggest me ..

[@user-Fatima.BHA.Shaikh]

How to save the check box in the data sheet?

[@ganeshthorve3053]

While saving machro nahi work karta hai

[@vijaysalma]

Sir please help to create Data form

[@AbhilashSKumar-hb9hw]

Need for Google sheets