Hi,

I have this monster of a spreadsheet on my hands that occupies
range("A1:AO80"). I need to optimize it and divide into a series of
smaller, more efficient parts. Here are the problems:

1. The sheet is not homogenius. There are 15-20 tables containing VERY
different sorts of data, all neatly bordered by the previous guy.
There is only one blank row/column between those little tables.

2. The workbook contains 30 of those sheets, one for each day of the
month, so breaking up tables into separate sheets and binding them
together with a consolidation sheet/VBA is out of the question.

3. I need to make everything scalable. I need to be able to add a row
to a table and go on with my life instead of adding a row, and then
taking care of 35 other tables on the same sheet that got split apart.
I know VBA on a decent level. Please help.



Thanks,


Mia