It worked great! Thank you so much for your help and effort on my question. It really helps a lot in my daily tasks and saves me lots of time which I can better spend on something else or simply just enjoy life a little bit more
Oh, I think it's because in my actual file, the value started from A2, but the test file started from A3...(normall my actual file will start from A2) Thanks for your help, your macro saved at least 30 mins of work today
Oh, I think it's because in my actual file, the value started from A2, but the test file started from A3...
Thanks again. It tested out very good except the macro doesn't work on the first cell but works well for the following cells in the column.
TEST FILE ATTACHED.
I just want to set up a macro which repeated to test cells in column A and insert rows based on the cell value (6, insert 1rows, 9,insert 2rows), perfectly if it can also copy the detail from the first row and fill it up into the new inserted rows. [attach=1226781]
Thanks Carim, it works exactly what I want but sorry I forget mention that how I can make it repeat to test the second cell of the column until the column finishes....
Please kindly help with my question. It's really appreciated!
What I want is
based on the value in a cell insert rows underneath.
only if a cell shows 6, then insert one row underneath
only if a cell shows 9, then insert two rows underneath
only if a cell shows 12 then insert three rows underneath
only if a cell shows 15 then insert four rows underneath
only if a cell shows 18 then insert five rows underneath
if the cell shows other number don't insert
Thanks for anyone can help!