Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-down box automation - cell duplication.
I have a workbook with a drop-down box that requires the user to select 'Yes'
or 'No' from it. If the user selects 'Yes', I would like the information in cells a1, c1, f1, h1 to be copied into destination cells (h7, i7,k7 m7) on another worksheet in the same workbook. I then require the active cell n7 to be highlighted on the same destination worksheet. If they select 'No' I don't require anything to happen. How can I achieve this? If the drop-down box prevents this event from occuring, are their any other options available? Lastly, the next entry for another user would be cells b1, c1, f1 h1 and if they select 'Yes' the code has to know to copy the information onto a new row below the last entry on the destination worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating drop downs in a cell contingent on another drop down | Excel Discussion (Misc queries) | |||
Duplication of items from a drop down list | Excel Discussion (Misc queries) | |||
List cell content without duplication or blanks | Excel Worksheet Functions | |||
Drop down list - copy from different workbook - Name duplication e | Excel Discussion (Misc queries) | |||
How do I stop duplication of cell data from a list (you can only . | Excel Programming |