+ Reply to Thread
Results 1 to 3 of 3

newbie question

  1. #1
    Registered User
    Join Date
    02-23-2005
    Posts
    7

    newbie question

    This is my first post, so please be patient. I would like to know the best way to compile some data. I send a single worksheet to approximately 120 offices in a company to complete and send back. I would like these answers to be compiled on a master sheet. There would probably only be 10-12 either text or numerical answers required for each "survey," so it is not a very large amount of data. I would like to know where to begin. Presently I am opening each email as it comes back and manually entering in a master spreadsheet. I know the basics of macros, but need to know how to save and compile the spreadsheets coming back in. Thanks for your help

  2. #2
    Forum Contributor
    Join Date
    02-15-2005
    Location
    Blackpool, UK
    Posts
    137
    Hi backbutton,

    I would approach this my saving the responses you get back in a directory. Create a new directory each time you publish the survey. Make sure that you save each response with a unique name, I suggest by putting a number on the end.

    You can create a master sheet with some VBA which has a loop for each file in the directory, open the file, get the data, save in the master sheet, move the ow pointers in the master sheet, close the response and get the next file.

    The only thing you might need to handle is pointing the master at the correct directory, you could store this in cell A1.

    The other way to go would be to put some VBA in the data sheet to open a master sheet, navigate to empty cells and copy the data across.

    Post some further questions if you need more specific pointers.

    HTH

    Art

  3. #3
    Registered User
    Join Date
    02-23-2005
    Posts
    7
    Thank you HiArt. I have followed your 2nd suggestion and placed a macro on the survey form that goes out to all. When I receive the survey back I can run the macro to get it on a master sheet. How do I edit the VBA to get the next survey to go to the next row down on the master sheet? or... any suggestions on how to write a loop using a macro on the master sheet to get it to open all of the other files in the folder. Thanks again, I really appreciate your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1