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
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)
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:
- Macro to add/remove rows based on highest # in group of cells
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add @ in laptop - Guide
- Excel macro to create new sheet based on value in cells - Guide
- How to add songs to sound picker - Guide
- How to add photo in word resume - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 4, 2015 at 10:57 AM
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
What do you mean by "sheet would have 9 rows"?
9 Rows of what?
Best regards,
Trowa