can anyone please help?

E_NYC_E

New Member
Joined
Apr 12, 2002
Messages
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.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top