Inserting a copy of a row
Hello!
I would like to make my sheet dynamic.. Here is an example of my scenerio:
Titles:
A1 = list of people
B1 = list of actions
C1 = Cost for action
A2, B2 would contain my drop down list but it would be set as blank, and C2
set to blank
Now if I were to select a name from my drop down list from A2, a row would
be automatically inserted at row 3 with A3 and B3 with my drop down list but
set to blank, and C3 set to blank. This would keep my list growing as I would
select names.
How would I go about doing this?
thanks!
|