(VBA) How Assign Column Cell To Corresponding Group, and Paste Group Cells into Groups WS?

Trying to write a VBA script for this, kind of confusing to explain, but here is the question:

(Link to workbook)

How do I group each list of Keywords into it's corresponding Group's worksheet, using VBA code?

Approach tried: I tried using a dictionary object, but couldn't wrap my head around it nor get it to work. To me it seemed like a decent solution, but I don't really know where to start on this script.


I have a list of Keywords in Column B, and each Keyword corresponds to a Group in Column A:

bjfzpe.jpg



Examples of Keywords corresponding to their respective Groups (worksheets), copied to Groups "Stainless Steel" and "Glass Dispenser":
Note: Keywords will be copied into Column A for each respective Group (worksheet)

Group (worksheet) "Stainless Steel":
mhspah.jpg

Group (worksheet) "Glass Dispenser":
111qow4.jpg


Any hints on where to start with the code / sample code suggestions? Any help would be greatly appreciated!

Hi eryksd

Filtering would be one approach.

Please attach a sample workbook the Structure of which is the same as your actual workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

Hi eryksd

Sorry, I didn't see your Link to Google Docs.

I must be missing something here but try this.

Insert this Code into a General Module. Assign it a Short Cut Key of CTRL + x (or add a Button).

Please Login or Register  to view this content.

Originally Posted by jaslake

Hi eryksd

Sorry, I didn't see your Link to Google Docs.

I must be missing something here but try this.

Insert this Code into a General Module. Assign it a Short Cut Key of CTRL + x (or add a Button).

Please Login or Register  to view this content.

It works!!! Thank you John!

That is some fancy code... trying to understand what's happening, ha

You're welcome...glad I could help. Thanks for the Rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Hi eryksd

Per your PM...

Do you know how I can also transfer the corresponding Avg. Monthly Search Volume (Column "D") for each Keyword, into it's corresponding Group Worksheet?

See if this works for you.

Please Login or Register  to view this content.