ExcelBanter - I have workbooks to consolidate data from on one report

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I have workbooks to consolidate data from on one report (https://www.excelbanter.com/excel-discussion-misc-queries/243267-i-have-workbooks-consolidate-data-one-report.html)

jyinlex

I have workbooks to consolidate data from on one report

I have 14 files on a network in different folders that i need to consolidate
data from. This was done so only the individual and myself could see the
files (security). I tried the consolidate function (excel 2007) but I get a
reference error.

Do I need to have all workbooks in one folder?

All times are GMT +1. The time now is 06:32 AM.