Im creating a database in Excel. I am hoping to have a user friendly form layout on sheet 1. Once the form is complete im hoping to submit (button) the info to sheet 2 and in the same instance reset sheet 1.
Sheet 2 is to be a basic looking database that will hold all the info submitted from sheet 1.
Could someone help me with this? i would really appreciate it.
Hope that makes sense
Thanks
Sheet 2 is to be a basic looking database that will hold all the info submitted from sheet 1.
Could someone help me with this? i would really appreciate it.
Hope that makes sense
Thanks