Simple Macro to Copy/Paste

[yankeez245]

Hello, I have a relatively straightforward macro that I would like to create.

In Sheet A, I have two columns. Column A, cell A1 is titled "Match." The rest of the cells below A1 either say "True" or "False." Column B is titled "new cars" in B1, then has a list of unique values in the cells below. Ie. Cell B2 says "2009 S-Class," "B3 says "2012 Audi Q8"...etc.

I want to make a macro that allows me to filter column A for only cells that say "True," and then copy/paste all of those corresponding values in Column B/Sheet A into Column A/Sheet B, column A. I then want to filter column A in Sheet A for "false," and copy/paste all of the corresponding values in column B into Sheet B, column B.

I have recorded a macro that does this but it doesn't seem to work. Any suggestions?

Thank you!

 

[Logit]

" Column B/Sheet A into Column A/Sheet B, column A. "

The above does not make sense. Too many columns or sheets. Please explain.

Secondly, it would be of great assistance if you could post a sample copy of your workbook for review. Make certain it does not
have confidential data (use markup data examples) and only enough to understand what you want to accomplish. A "before/after"
presentation if you will.

Thanks.