Need help with storing data [Closed]

Report
Posts
1
Registration date
Tuesday March 21, 2017
Status
Member
Last seen
March 21, 2017
-
Hello Guys I am new to ccm.net 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