I've just been handed an Excel workbook with two sheets of data, with one being the first 65000 records, and the next being the continuation (another ~35000). The user would like to be able to sort the data and combine it so that records with a given value in one column could appear on the same sheet, and he could get a total for a couple values in other columns for each of the sort values. I'm sure there's a fairly easy solution for this using one of the lookup functions or something, but I'm pretty rusty on my fancy Excel junk.
TIA
Bookmarks