Long time reader, first time poster.
I'm trying to create an excel file to help me stay organized.
I know how to pull data from one worksheet to another with formulas. So for example one on my worksheets is my "main database" that has fields like "first name, last name, phone number, email, etc."
Another worksheet has formulas that pull the data from the main database worksheet.
I was wondering how it's possible to do the reverse.
So have worksheet1 that I can enter data into cells "first name, last name, phone number, email, etc." and have those cells copied to the next line of worksheet2.
Effectively using worksheet1 to be the data entry face of the database of worksheet2.
(so that worksheet3 would be able to pull all the data entered in worksheet1 and stored in worksheet2)
Sorry if it sounds confusing, let me know if you get it and how to do it, or if I should elaborate.