New to programming for excel. Want to run a script to add rows beneath each row based on the value in one of the cells in that row and then move to the next row of data and do the same.
For example:
Cell E5 = 7, I want to Insert 7 rows beneath row 5, then move to the next row and insert the number of cells equal to the value in column E of that row.
Not sure how/where to enter the script either. I'm fine with in-cell formulas, and using the record-macro tool, but have little experience writing and running scripts in excel so as detailed as possible would be greatly appreciated.
Thanks so much
Bookmarks