Hi all!!
Its been long, hope all are doing good.
I have a Consolidated workbook where I am trying to combine all the sheets in a folder and sub folders with in it.
My source workbooks has a sheet named "ABSTRACT" from which I am looking to extract the following cell values: B5, B6, B7, B8, F6, F7, F8, and values corresponding to TOTAL COST, and NETT PAID in column F.
I want all these values in my consolidated workbook in incremental rows started from row 2 i.e., row 2 then row 3 then row 4 etc for each source workbook.
Apart from the above values, I want 'file name', 'file hyperlink', 'file path' in the last three columns after above data is populated.
I have attached two source workbooks and Consolidated sheet.
I don't want to hard-code the file path, I want to able to select folder by myself.
Please help.
Bookmarks