| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to Save data
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro to Save data
Maybe...
And Debra Dalgleish added some stuff he http://contextures.com/xlForm02.html and maybe he http://contextures.com/xlForm03.html Paul Rimmer wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro to Save data
Cheers Dave,
Will give this a try & let you know the outcome. Paul R "Dave Peterson" wrote: Maybe... And Debra Dalgleish added some stuff he http://contextures.com/xlForm02.html and maybe he http://contextures.com/xlForm03.html Paul Rimmer wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a macro that sorts data when I click save? | Excel Discussion (Misc queries) | |||
| macro to save as a data input by user file name from a designated | Excel Discussion (Misc queries) | |||
| Creating a macro to save only partial data | Excel Discussion (Misc queries) | |||
| save original data after macro is run again | New Users to Excel | |||
| help with macro to save repeating data entry | Excel Discussion (Misc queries) | |||
Linear Mode
