Hi, I am new to excel and VBA. I am trying to create a excel file with sheet 1 is bio data form entry which would automatically populate table on sheet 2. So every time someone click submit on sheet 1, some data from sheet 1 get added to sheet 2 and sheet 1 data clears.