Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting data from other workbooks
Perhaps this has been discussed before, if so please point me to that
discussion. Someone has set up a survey in an Excel Workbook. This will be sent to a number of respondents. What I would like to do is to set each question up to a column then run a macro that would open a workbook (several in sequence) and read the data from a specific cell then insert it into the next empty cell in a column. AND, as if you hadn't already guessed, I later would want to total the results (not a problem) and insert the total results back into a blank copy of the source Workbook. I feel it would be better to have this Macro in the totaling workbook rather than modifying the survey workbook. Any suggestions would be welcomed. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting data from other workbooks
Ron de Bruin has a variety of related scenarios coded on his site. Take a
look there and see if you can't adapt one to your particular situation: http://www.rondebruin.nl/tips.htm -- Regards, Tom Ogilvy "Jim at SDSU" wrote in message ... Perhaps this has been discussed before, if so please point me to that discussion. Someone has set up a survey in an Excel Workbook. This will be sent to a number of respondents. What I would like to do is to set each question up to a column then run a macro that would open a workbook (several in sequence) and read the data from a specific cell then insert it into the next empty cell in a column. AND, as if you hadn't already guessed, I later would want to total the results (not a problem) and insert the total results back into a blank copy of the source Workbook. I feel it would be better to have this Macro in the totaling workbook rather than modifying the survey workbook. Any suggestions would be welcomed. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting data from other workbooks
"Tom Ogilvy" wrote:
Ron de Bruin has a variety of related scenarios coded on his site. Take a look there and see if you can't adapt one to your particular situation: http://www.rondebruin.nl/tips.htm -- Regards, Tom Ogilvy Looks good--THANKS!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting charts into many workbooks | Charts and Charting in Excel | |||
Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
Inserting rows in multiple workbooks | Excel Discussion (Misc queries) | |||
inserting a sheet into multiple workbooks | Excel Discussion (Misc queries) | |||
inserting sheets into existing workbooks w/o external references | Excel Worksheet Functions |