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