The challenge is in Visual basic, but I might be wrong.
I will need a MS Excel script to help me to MANUALY sort (need human interaction!) a list of keywords based on a category list.
The categories are listed in a Categories tab and the keywords are in a Keywords tab.
When the script starts (I push the Start button), I need it to ask me what line to pull the first keyword from and then show it in the Categories tab - this tab will be the one where I need to work on.
Then I click on categories where I want keyword to belong.
Every time when I click on a category, the respective category is selected and transposed/copied in a column in the Keywords tab besides the keyword I am working with.
When I finish with the selections for all categories, I should push a Done button to move to the next keyword.
If I want to stop and save the work, I want an End button that will terminate the script session.
See the attached excel for details.
Please PM me if you have any questions.
Thank you.