Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheet to Sheet info transfer
I'm trying create a form that will ask people to fill out info (i.e. address,
phone, etc) then reset when it is completed. Is there a way I can create a form that will ask info and have my user submitted in some way that will reset the form for the next user? At the same time the info of all users go to a pre-made spreadsheet that will hold all imputed info? Does this question make any sense to anyone? -- -Daniel Ramos Freelance Photographer |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheet to Sheet info transfer
A UserForm sounds like the way to go.
John Walkenbach has a free enhnanced Data Form add-in that should fit your needs. http://spreadsheetpage.com/index.php/dataform/home Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 13:01:03 -0700, gLightFoto wrote: I'm trying create a form that will ask people to fill out info (i.e. address, phone, etc) then reset when it is completed. Is there a way I can create a form that will ask info and have my user submitted in some way that will reset the form for the next user? At the same time the info of all users go to a pre-made spreadsheet that will hold all imputed info? Does this question make any sense to anyone? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfer contents from a cell in previous sheet if the sheet is a | New Users to Excel | |||
How to Automatically transfer specific Data from Sheet 1 to Sheet | Excel Worksheet Functions | |||
HOW DO I TRANSFER INFO FROM POSITION CHART TO A SCHEDULE SHEET? | Excel Worksheet Functions | |||
transfer info from one sheet to another? | Excel Discussion (Misc queries) | |||
Transfer info from one sheet to another | Excel Discussion (Misc queries) |