can anyone please help?
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: can anyone please help?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com