Hi
I've tried to research retrieving data from a suite of (closed) workbooks and placing it in a list in a master workbook, but can't get my head around loop coding.
I have a variable length list of workbook names in the Master workbook in column AZ (AZ3:AZ) on sheet named "Running Order".
Each workbook has only one sheet in it and is stored in a folder on my C drive.
I can recall each workbook individually with the CodeThe name of the Folder is variable with the name of the current folder held in cell F1 of "Running Order".Please Login or Register to view this content.
The individual CorrectbookName is variable and = Range("AL1") & (".xlsx")
Each worksheet in each Workbook holds a variable length of data in columns DA, DB & DC.
Columns DB or DC will be of the same length and will dictate the number of rows of data to copy.
At the click of a button I want to loop through each workbook in the list in Running Order AZ3:AZ and copy the data form each of the workbooks sheets DA:DC to paste values in to a list in columns A2:C on the sheet "Results" in the Master workbook.
As I've said, I have tried to find a suitable code and adjust it to work, but have seriously failed and cannot get my head round how Loops work.
Anyone have any rough codes I could use as a starter or, (even better!) a code that is known to do what I want?!!
Thanks in advance for your assistance.
Frankie
Bookmarks