I need to be able to count the active rows (A:A) in a remote worksheet. There are about 75 of them.
I have this formula working...
But I was hoping to just Concatinate the string string based on columns instead of typing the formula each time - such as...
C:\Xref_Files\ [XREF 1.xlsx] Sheet1! A:A
C:\Xref_Files\ [XREF 2.xlsx] Sheet1! A:A
C:\Xref_Files\ [XREF 3.xlsx] Sheet1! A:A
And build the formula based off of this. Any ideas?