Hi all
I have a spreadsheet set up as a form where the user selects a site location and the other fields (i.e Address) auto populate based on a table I have on a back sheet.
This works fine. But if the user needs to add a new site and details I want to have a user form where the data is entered in the next line of the table. I have not created the form yet. I am trying to understand how I can do it first.
So for example my table is on sheet 3 and looks like the below
Name Number Address Suburb State Postcode Phonenumber
Any Help would be appreciated.
Thanks in Advance
Some people make things happen, some watch while things happen, and some wonder 'What happened?'
I have a spreadsheet set up as a form where the user selects a site location and the other fields (i.e Address) auto populate based on a table I have on a back sheet.
This works fine. But if the user needs to add a new site and details I want to have a user form where the data is entered in the next line of the table. I have not created the form yet. I am trying to understand how I can do it first.
So for example my table is on sheet 3 and looks like the below
Name Number Address Suburb State Postcode Phonenumber
Any Help would be appreciated.
Thanks in Advance
Some people make things happen, some watch while things happen, and some wonder 'What happened?'