PDA

View Full Version : Loop? Copy/Paste from to Summary from Workbooks on Server



Fretflyer
10-10-2012, 11:14 AM
Thank you in advance, I am very new to VBA and have been trying to figure this out on my own for months but I am over-frustrated and getting nowhere.

My goal: copy/paste data from "job-files" to "summary file."

"Job-files" are named "C1001data", "C1002data", "C1003data", etc. and have multiple worksheets in each. They all have the same sheet names.

I have multiple locations to deal with for example:
O:\Jobs\Jobs In Progress\C1001-Job 1\Other\C1001data
-or-
O:\Jobs\Jobs Finished\C1002-Job 2\Other\C1002data

Several cells need to be copied from the "job-files" to the "summary file." in a particular destination cell (don't have one yet).

Sorry if that's confusing, I am kind of confused myself:(

Any help MUCH appreciated.