Sephiroth wrote:
Dear,

I have an excel file with tons of data, multiple sheets (~63MB in size). I
want to compile it into one sheet and make use of vlookup. But I encounter
the limit which one sheet cannot exceed 65536 lines...appreciate any
suggestions ^_^

Excel 2007 allows up to 1 million lines.

Personally, I like the Access front end approach suggested by another
poster.

Bill