Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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)
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
How to undo "remove link" in bio?
mary22 -
Gourav -

13 responses