Need help with storing data

muhammed361 Posts 1 Registration date Tuesday March 21, 2017 Status Member Last seen March 21, 2017 - Updated by muhammed361 on 21/03/17 at 05:25 AM
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