Transferring summary data from multiple workbooks with varri

Mtaylorlc · Apr 1st, 2002, 06:04 PM

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 · Apr 1st, 2002, 09:47 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 1st, 2002, 06:04 PM	#1
Mtaylorlc New Member Join Date: Mar 2002 Location: Charlotte, NC Posts: 40	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

Apr 1st, 2002, 09:47 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	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.