I need to help with setting up macros and VBA. I want to archive data from my 'Tracker' sheet into my 'Archive' sheet using a 'submit' button. I want to be able to keep the data in the archive sheet, but clear the data in the tracker sheet ready for numerous other submissions. I also want the data from the 'Tracker' sheet to populate a specific cell which is identified by a person's name (Y-axis) and date (x-axis) in the 'Archive' sheet.
Solved by S. Y. in 26 mins