| Home > Forum Home > Automating Data Analysis Tasks > Auto copy from drop down list to three new sheets > VBA onchange event | Share |
VBA onchange event
Excel Help for Vba Onchange Event in Automating Data Analysis Tasks
| Forum Topic | Login |
Vba Onchange Event | Rate this: (3/5 from 1 vote) |
 | You could create some VBA code and add it to the OnChange event of the either the worksheet in question or the dropdown list. The code should then include an If function to evaluate the option chosen. This may be from a cell link of the dropdown list. The code would then copy rows and insert them into the correct sheet and then go back to the originating sheet and delete the rows copied. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for VBA onchange event in the Excel Business Solutions Directory |