ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting a copy of a row (https://www.excelbanter.com/excel-discussion-misc-queries/116905-inserting-copy-row.html)

Ninjapowa

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!




All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com