Forum Discussion
yeliestefani
Feb 24, 2023Copper Contributor
Move rows to sheet with drop down selection
Hello, I just discovered VBAs, I know where to place them, but I need assistance putting them into effect. I also need assistance creating a code that would allow me to move entire rows to another s...
peiyezhu
Feb 26, 2023Bronze Contributor
Do you want a key words picker?
Do you mean when you select one word option from the drop down then a row will be selected to fill another sheet?
- yeliestefaniFeb 26, 2023Copper Contributor
Thank you for responding!
Not really, I would like for the row to move to the respective sheet when selected from the drop down. The drop down items are the name of the sheets I would like them to go to.
- peiyezhuFeb 27, 2023Bronze ContributorAs to vba,please refer to SnowMan55's post.
Because it is not easy auto generate drop down input box, try this online tool which may help to re-categorize all rows.
http://e.anyoupin.cn/ceshi/jstest/pull_up_demo.php?s=selected_