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)

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

Answer 1 / 1

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

Similar discussions

help me to add particular cells

Fill adjacent cell with number from text answer

Call barring cancel code

Reset call barring

Similar discussions

Subscribe To Our Newsletter!