macro to edit table rows

[Pete]

see attached workbook
Hi Experts

Need a macro that will increase and decrease the number of rows in each of the three tables accorinding to the data populated into each table. If no data is enter into any one of the table maintain five empty rows as shown in worksheet "Latam Santander".

One key point is that the gap between the tables must remain at two rows. apart.

[rbrhodes]

Hi Pete,

looks familiar!

[Pete]

Hi dr...

Yes the last and final part........

[Pete]

Hi dr,

Just a bit of additional information....

The tables do not stay the same.....if data entered into table A then the number of rows in that table can increase of decrease. Likewise with table b and c.

Say for example we have the following data populated into tables A, B and C.

table A has increased from 5 empty rows to 7 full rows of data

table B has deacresed from 5 empty rows to 3 full rows of data

table C has neither increase or deacreased but has five rows of full data...

KNOW when the user click the clear old data macro button......then and only then i want the macro to reset the tables back to there current state. AND

The macro has to adjust each table accordingly to the amount of data the each table has....and maintain this present of 2 rows between them.

i hope this helps