Get File name and Row Count from Given Network Paths

[dhavalrg]

Hi All,
I need to update Spreadsheet daily with following data.
In whole process i need to play two spreadsheets.
Spreadsheet#1 Contains Network paths
Spreadsheet#2 Contains Data.
Step :-1 Need to Go to Network Path given in Excel containing paths
Step :-2 Get the latest file name and row count and add them to data spreadsheet.

To automate this activity i have created two formulas
Formula#1 Gets file names automatically for the paths added while creating formula
Formula#2 Get Dates from File name and adds it date column
So my Sheet#1 looks like given below
DateFile NameRow Count
Current Date-1Latest File from Path1Row count of the file
Current Date-1Latest File from Path2Row count of the file
Current Date-1Latest File from Path3Row count of the file

Now I need suggestion to get Row count of the files appearing in Column#2.

 

[SirJB7]

Hi, dhavalrg!
Welcome to Chandoo forums!
Checked this yet?
http://chandoo.org/forum/forums/new-users-please-start-here.14/
Regarding your question, this is a recent post about last row, maybe you find it helpful:
http://chandoo.org/forum/threads/how-to-get-the-last-used-row-number.34132/reply?quote=203333
Regards!