Need help with storing data [Closed]

Registration date
Tuesday March 21, 2017
Last seen
March 21, 2017
Hello Guys I am new to and excel.

My question is, how can i save one excel data to another ..
Let me explain in detail...
I want to make a design in sheet1 for inputting data and i want that data to be stored in sheet2 or workbook2.xlsm but i don't want to save anything on sheet1. it will be a portal to just insert data and that data to be stored in sheet2.
the sheet1 show not save any cell data but only the page design

sheet1 one should act as a form just like how html gets the data and stores it in SQL same like that

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!