Hello forum genius! Just wondering if anyone can help with a loop for a macro?
I have managed to scrape this together
Sub OpenFile() Dim wkb As Workbook, wkbFrom As Workbook Dim fromPath As String ' Get path from cell A1 on Report tab fromPath = Sheets("Reports").Range("A1") Set wkb = ThisWorkbook Set wkbFrom = Workbooks.Open(fromPath & Range("B1").Value)
I managed to get this to open the file listed in cell B1.
However, I don't know how to loop this to then go across to C1, D1 until F1), of which some might be blank.
Then I have to loop this downwards ie B2 ... F2.
Can someone help?