Hi all . I'm new be kind. I need a formula to insert copies of the current row to a insert a 1,2,or 3 rows directly below. Scenario: I need to survey people. If i have 1 person in a survey, I would say put the number 1 in cell A3 for example. If there are 3 persons in my particular survey then I need to record details for all 3 people; so if A3 = 3 then I need excel to insert 2 more rows for me. cant be that hard.. is it? preferably want it to copy the current row and paste in directly below. Thanks in advance.
Bookmarks