Hi All,
hope someone can help to achieve the below.
I am working on an excel file as attached file, tiger.xls
this is what i am trying to accomplish to write in Marco.
Part A:
in the H column, i need to insert the # of row minus the number that is in the cell. for ex. when
H2 = 3, to insert 2 blank row down
H3 = 2, to insert 1 blank row down
however, if the cell is 1, then do not add any row
Inserting the blank row should come to a STOP whenit reaches [Total] on colunm A.
when this is done, the file shouuld like file as attached: lion.xls
Part B:
Auto populate the number in an increasement format in the empty cells follow by the Max# in Column A.
in this example, in Colunm A the max# is 10. so
the first empty cell [A3]l should be listed as 11.
The increasment should be carried on, unitl it reaches a smaller number.
in this case:
A3 = 11
A4 = 12
A5 = 2
stop, and then
A6 = continue to auto populate [increasement] from last Max #
which means, A6 = 13
auto populate number should be stopped when it reaches to the cell [Total]
the final file should look like as attached, bear.xls
Appreciate for any thoughts and comment.
Regards
Bookmarks