Retrieve data from different workbooks in the same file with conditions...
Posted on 2011-09-20
I need to retrieve values from a lot of files which are saved in the same file C:\Users\Roberto\Desktop\TEST
All files are made from the same Template.
The range to "import" is always the same: A15:N259 in Sheet "RELLENAR".
1) Each row imported to the Summary Workbook must have in column A the value that is in Cell B3 in the target Workbook.
2) Blanks or Empty rows MUST not be exported.
3) For each row in the range A15:N259....When there are rows that have the same values in columns A,D and E, I would like to receive the SUM of Column N for all the Rows that match the three values.
Could you help ?
Thank you very much for your time.