Macro to add/remove rows based on highest # in group of cells [Solved/Closed]

Report
Posts
1
Registration date
Wednesday June 3, 2015
Status
Member
Last seen
June 3, 2015
-
Posts
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
-
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

Posts
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
461
Hi Joermccartney,

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

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!