Hello forum genius! Just wondering if anyone can help with a loop for a macro?
I have managed to scrape this together
Code
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?