Transferring summary data from multiple workbooks with varri

[Mtaylorlc]

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

 

[Qroozn]

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.