thespardian
Board Regular
- Joined
- Aug 31, 2012
- Messages
- 119
- Office Version
- 2016
- 2013
- Platform
- Windows
Hi there!
Please accept my apology in advance. I know similar questions have already been posted in this forums but being a dumb with VB codes I could not amend them for my purpose.
I tried my level best to solve my problem with the help of the link given below
https://www.mrexcel.com/forum/excel...ltiple-excel-files-into-one-summary-file.html
but I was unable to do so because of my zero knowledge about VB. So I decided to request you guys. Please help me in matter given below.
I have more than 94 workbook macro enabled files in a folder “TA” (C:\Users\xyz\Desktop\TA). The data format of all the files is same. The names of some files are alpha-numaric (e.g DINA 1-1.xlsm, DINA 2-2. xlsm, DINA 3-3. xlsm) and others are numeric (e.g 1234567. xlsm, 7654789. Xlsm)
The target sheet on all 94 workbooks is sheet “T.Advnce”.
On the target sheet i.e “T.Advance”, the data is extracted from other sheet (of same workbook) using array formulas. The array formulas are entered in the range A7:E106 & A110 : E209. So we have some data rows and blank rows in the above mentioned range.
I want to pull this extracted data only (ignoring the blank rows in range A7:E106 & A110 to E209) from sheet “T.Advance” to another workbook named REPORT which is present in the same folder.
Any help would be highly appreciated.
Please accept my apology in advance. I know similar questions have already been posted in this forums but being a dumb with VB codes I could not amend them for my purpose.
I tried my level best to solve my problem with the help of the link given below
https://www.mrexcel.com/forum/excel...ltiple-excel-files-into-one-summary-file.html
but I was unable to do so because of my zero knowledge about VB. So I decided to request you guys. Please help me in matter given below.
I have more than 94 workbook macro enabled files in a folder “TA” (C:\Users\xyz\Desktop\TA). The data format of all the files is same. The names of some files are alpha-numaric (e.g DINA 1-1.xlsm, DINA 2-2. xlsm, DINA 3-3. xlsm) and others are numeric (e.g 1234567. xlsm, 7654789. Xlsm)
The target sheet on all 94 workbooks is sheet “T.Advnce”.
On the target sheet i.e “T.Advance”, the data is extracted from other sheet (of same workbook) using array formulas. The array formulas are entered in the range A7:E106 & A110 : E209. So we have some data rows and blank rows in the above mentioned range.
I want to pull this extracted data only (ignoring the blank rows in range A7:E106 & A110 to E209) from sheet “T.Advance” to another workbook named REPORT which is present in the same folder.
Any help would be highly appreciated.
Last edited by a moderator:
