First, you're asking in a Mac XL group - the feature basically works the
same in any version, but just wanted to make sure you knew as it can make a
difference for certain other features. In fact, if your consolidation
involves multiple workbooks - especially if they're in different directories
- the syntax requirement on a PC is somewhat different than on a Mac.
Secondly, you really don't provide enough in the way of detail for anyone to
determine what the problem might be. It's fairly clear how to get into the
Consolidate dialog, but the whole issue revolves around the references &
settings you make once you get there - and you provided nothing specific
about that. Without knowing what references you're entering or the settings
you're using one can only surmise that there is an error with them or - more
likely - with their syntax. This is especially true if you are actually
trying to consolidate data in separate workbook files.
In general, I've always found it most accurate to open the source files and
select the ranges in each rather than trying to type them accurately - I'm
not the best typist in the world & I'd prefer to let the program comply with
its own syntax requirements
Regards |:>)
Bob Jones
[MVP] Office:Mac
