Create a form that enters data into a spreadsheet

[rockychips]

Hi

I'd like to create a form that will transfer the data entered to a hidden spreadsheet so that only I can see all the entries that have been made. I've had a look at various youtube clips and kind of get the impression it's either a userform or data entry form that I need to create and possible with VBA which I am a complete beginner on. I have the spreadsheet already set up all I want is for the rows to be filled in using some sort of upload / transfer from another sheet - ensuring that all the data entered remains confidential (only I can see the details).

I hope this makes sense? Any help on this would be much appreciated.

Thanks
Shane

 

[rockychips]

Hi again
I've had a play with this today and found a simple macro that creates the basic form to transfer the data over, but still need to find a way to hide the data. I think it will need to be in another workbook and upload from one sheet to another. Shall keep looking, happy for any pointers on this.

Thanks