Count active rows in a remote WS
Hello,
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...
=COUNTA('C:\Xref_Files\\[X
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?
Thanks,
Trish
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...
=COUNTA('C:\Xref_Files\\[X
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?
Thanks,
Trish
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I got it fixed using your formula! They are naming the tabs! When i changed it to the name of the tab it works great.
Thank you!
Thank you!
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER