I have a very large ( 400 MB) excel 2003 file broken into 18 tabs. I have
converted it to Excel 2007 (.xlsx). Each tab goes to column DD ( so about
108 columns) and they range from 20,000 - 60,000 rows. I am trying to
condense all the information on 1 worksheet in a 2007 format. The problem is
that whenever I try to copy the data, I get the error that the destination
size doesn't match the source size. I select the first cell (upper left hand
corner ) of where the cells should go, change over to the next tab, select
all the data, copy, switch back to the first tab, and try to paste in the
highlighted cell. This generates an error. How do I do this?