can anyone please help?

E_NYC_E · Apr 13th, 2002, 07:55 AM

i have a survey to send out every day. at the end of tha day people fill it out and send it back 2 me. now at the end of the week i end up with way too many surveys which i have to manually cut and paste from every individual survey to tally up the results. my question is is there an easier way for me to integrate all the documents into one and have excel tally up the results? all the surveys are in the same format.

Mudface · Apr 13th, 2002, 01:08 PM

If your surveys are on a network, you could link them all to one master document, possibly. Alternatively, it would be fairly easy to record or write a macro to loop through your surveys and copy and paste into your overall document.

Tom Schreiner · Apr 13th, 2002, 01:47 PM

Hi
Same solution as MudFace...
Have several examples of different "dump" type update the ole master workbook examples if you need any.
They are similiar to your needs.
One is for an unsurance company which uses a template for auditing. These many audits are then "dumped" into one folder and the master is updated with them all.
Another does the same exact thing for timesheets.(About 200 per week)
Fairly easy.
This assumes that all of your surveys are in the same format.
If you'd like, send me several sample templates of surveys, and then a sample of
the endresult of your tally.
TsTom@Hotmail.com
Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 13th, 2002, 07:55 AM	#1
E_NYC_E New Member Join Date: Apr 2002 Posts: 1	i have a survey to send out every day. at the end of tha day people fill it out and send it back 2 me. now at the end of the week i end up with way too many surveys which i have to manually cut and paste from every individual survey to tally up the results. my question is is there an easier way for me to integrate all the documents into one and have excel tally up the results? all the surveys are in the same format.

Apr 13th, 2002, 01:08 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	If your surveys are on a network, you could link them all to one master document, possibly. Alternatively, it would be fairly easy to record or write a macro to loop through your surveys and copy and paste into your overall document.

Apr 13th, 2002, 01:47 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Same solution as MudFace... Have several examples of different "dump" type update the ole master workbook examples if you need any. They are similiar to your needs. One is for an unsurance company which uses a template for auditing. These many audits are then "dumped" into one folder and the master is updated with them all. Another does the same exact thing for timesheets.(About 200 per week) Fairly easy. This assumes that all of your surveys are in the same format. If you'd like, send me several sample templates of surveys, and then a sample of the endresult of your tally. TsTom@Hotmail.com Tom