Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Append data to a separate workbook
I have built a survey that will be sent to multiple users. The users will
complete the survey and then click a submit button. What I need to happen once that submit button is clicked, is for the results to append to a summary file. Below is an example of the structure and data. Survey.xls Results Worksheet A B 1 Q1 4 2 Q2 5 3 Q3 2 Survey Results.xls (location: F:\Results) I need the data in range B1:B3 of the "Results" worksheet to automatically append to the next available column of the "Survey Results" workbook. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation from list on separate Workbook | Excel Discussion (Misc queries) | |||
How do I append data to an Excel workbook using a template? | Excel Discussion (Misc queries) | |||
Append workbook into a "Master" workbook | Excel Discussion (Misc queries) | |||
filter data from 10+workbooks and display in separate workbook? | Excel Discussion (Misc queries) | |||
Append data in a separate spreadsheet using a Macro | Excel Programming |