Hi Team,
Hoping someone can help me.
I have a sheet with boxes that captures some user data (name, email, contact etc) and I call that sheet 1 - Input Sheet. I then use this to fill information in on that person.
When I hit save, I want that data to be copied into Sheet 2 - Output sheet but across in rows. Then it should empty the contents of Sheet 1, ready to fill it in again.
I can't get it to work....maybe some one can help. I have copied screen shots of both sheets.
(Disregard my styling I will fix all that when I know its working)
Hoping someone can help me.
I have a sheet with boxes that captures some user data (name, email, contact etc) and I call that sheet 1 - Input Sheet. I then use this to fill information in on that person.
When I hit save, I want that data to be copied into Sheet 2 - Output sheet but across in rows. Then it should empty the contents of Sheet 1, ready to fill it in again.
I can't get it to work....maybe some one can help. I have copied screen shots of both sheets.
(Disregard my styling I will fix all that when I know its working)