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

It sounds like your goal is for ease of maintenance.

Whenever one of those tables needs modification, the same modification is
necessary on 29 other sheets.

One option is to write a macro whenever you need to make a change. This
macro could be run against the remaining sheet.

Another option would be to partially rewrite.
Instead of 30 sheets each containing 20 tables
Try: 20 sheets (tables) each containing 30 days of data.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Mia" wrote in message
ups.com...
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