Welcome to WebmasterWorld Guest from 54.145.166.96

Forum Moderators: phranque

Message Too Old, No Replies

Excel help. is this possible

   
2:29 pm on Jun 21, 2006 (gmt 0)

10+ Year Member



I have a spreadsheet that has dropdown feature. I want the value of the drop down to populate the next blank cell.

A1 = drop down menu
A4 = first empty cell

I want the value from the A1 drop down to populate A4, next time it will populate A5.

Is this possible?

Thanks

8:31 am on Jul 3, 2006 (gmt 0)

5+ Year Member



All this is possible in Excel - you need to check the documentation for VBA or for making macros - this can be done programatically. You will probably have to have and event for when the drop-down box is clicked.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month