Create a form sheet that automatically adds rows to a lookup table on another sheet

Copper Contributor

I work for a boat repair company and I'm trying to create a new customer form.

Essentially I'm looking for one page that has the form on it, and then a save button or something that will automatically add the info to a row on another worksheet. 

The more I think about it, the more complicated I think this is going to be.  

I'm pretty good with formulas, but I just can't find one that fits what I need.

 

Any responses appreciated!

1 Reply