Macro to add/remove rows based on highest # in group of cells

Solved/Closed
Joermccartney Posts 1 Registration date Wednesday June 3, 2015 Status Member Last seen June 3, 2015 - Jun 3, 2015 at 10:15 AM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Jun 4, 2015 at 10:57 AM
I am looking for a macro that will look at a predefined group of cells (say A1-A5) and create as many rows based off the highest one on another sheet.

Example:
A1 - 3
A2 - 5
A3 - 1
A4 - 9
A5 - 4

In this case the other sheet would have 9 rows.
Then if someone changes A4 to 2, the amount of rows on the other sheet should decrease to 5 (the new largest value)

1 reply

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Jun 4, 2015 at 10:57 AM
Hi Joermccartney,

What do you mean by "sheet would have 9 rows"?
9 Rows of what?

Best regards,
Trowa
0