Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Tab function not working Curt Excel Discussion (Misc queries) 3 September 27th 06 09:44 PM
copy with format horst New Users to Excel 16 September 25th 06 09:43 PM
Disable Cut & Copy then restore on exiting sparx Excel Discussion (Misc queries) 0 April 30th 06 08:43 PM
copy between worksheets does not copy formulae just values Chris@1000 Oaks Excel Discussion (Misc queries) 0 March 19th 06 11:44 AM
Copy without Hidden Cols - How abrogard Excel Discussion (Misc queries) 1 July 15th 05 07:54 AM


All times are GMT +1. The time now is 08:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"