Macro to Save data

[Paul Rimmer]

Hi Guys,

I'm new to macro's, but I've heard that when I input data into a excel
spreadsheet designed as a form. A macro can be used to save the data in a
seperate spreadsheet in the next available row, so that multi user's can
input info at the same time. I would like to be able to have the second sheet
password protected if this is possible.

I'm trying to design a Holiday Request sheet & would really appreciate some
help on this.

Cheers in advance.

 

[Dave Peterson]

Maybe...

And Debra Dalgleish added some stuff here:
http://contextures.com/xlForm02.html
and maybe here:
http://contextures.com/xlForm03.html

 

[Paul Rimmer]

Cheers Dave,

Will give this a try & let you know the outcome.

Paul R