Transferring summary data from multiple workbooks with varri
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Transferring summary data from multiple workbooks with varri

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Charlotte, NC
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Help! I'm about to pull my hair out... and I don't have much to spare!

    I am currently developing a checklist that will be distributed to about 120 offices. These offices will fill out the checklist and return to me. I then intend to drop all of the completed checklists into one folder. I have a few cells at the bottom of the sheet that summarize their responses. I would like to transfer these cells from each of the completed sheets to one "summary" workbook. This will be an ongoing process and I would like to be able to accomodate different file names. I had intended to create an array to read the filenames into a range and then enter each filename from the range into a looping array that would pull the summary data from each workbook in the folder and paste it... one row for each workbook. My sucess has been very limited. I would be happy to e-mail the existing workbooks (sample checklists and summary workbook) if that would help. I am not yet convinced that bald is beautiful... please help save my hair!

    M Taylor

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    538
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I have created an excel form. which is distributed nationwide.
    I have a summary sheet that then copies all the "summary cells" from each worksheet.
    these all get added to the summary sheet by a single"import" macro.

    I dont use arrays but a simple copy & paste that goes into each seperate worksheet.
    I dont know it satisfies my people.

    e-mail me if you want me to have a quick look at it.

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