Consolidate function

[quig699]

Hi,

I am trying to use the consolidate function in excel to pull data from mutiple identical spreadsheets into a master sheet. If I use the consolidate function it works fine. If I try to make a macro of it I keep getting error messages that there are too many data sources. I am trying to link 30 spread sheets, one for each employee.

Any thoughts???
Thanks

Amy

Thanks,

Amy

 

[SkipVought]

Hi,

the consolidate function in excel

There is no comsolidate function in Excel!

What are you referring to? Some Add-on?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

maybe you're referring to one of several of the consolidate features in Excel. If so, which one?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[kjv1611]

If you're basically trying to query 30 different worksheets, that may be getting a little large for Excel, I would think. I mean, I'm sure it can do it, but I wonder if Access would be a better tool for this, regardless. Then in Access, you could have your 30 tables, and set up a query there....

Or better yet, one large master table with an extra field, designating the EmployeeID or something, so you just filter your query results each time with that, or group by that.