Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking a form to a spreadsheet
I want to send out an excel form for completion by users, then have it
returned, but have a quick way of transferring the answers from the form into a columnar spreadsheet, is this possible with a macro button or something. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking a form to a spreadsheet
Hi, Matt -
One way of doing what you want is to use a row on the form to gather the information as the user completes the form. I.E. Insert a new row 1. In cell A1 enter = and click on the cell that contains the user's name. Continue across the row capturing all the data from the form. Then change the font in row 1 to white. You'll want to protect that row so the cursor doesn't land on it. When the user completes the form and sends it back to you, you can copy and paste it into the next row on your spreadsheet. Hope this helps, Carole O "Matt-Sheff,UK" wrote: I want to send out an excel form for completion by users, then have it returned, but have a quick way of transferring the answers from the form into a columnar spreadsheet, is this possible with a macro button or something. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Put form fields in Word forms into an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
How 2 create an Excel Form using & linking items on Forms Toolbar | Excel Discussion (Misc queries) | |||
Auto refreshing and printing a form with data from each row of a spreadsheet | Excel Discussion (Misc queries) | |||
Print a data entry form without the spreadsheet as a background? | Excel Discussion (Misc queries) | |||
User form and hiding spreadsheet | Excel Discussion (Misc queries) |