I have workbooks to consolidate data from on one report

J

jyinlex

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help on consolidate worksheets from different workbooks into one 2
consolidate workbooks to worksheets in one workbook? 1
Consolidate work sheets 1
Weekly Report 2
Design to consolidate data 0
Design to consolidate data 0
How do I consolidate data into ranges 8
Help - need to consolidate workbooks 3

Top