VBA Copy paste code

[tyrese215]

I need a nice button to on tab named "Control" with the following VBA code to achieve the following:
In "BBB" tab copy entire columns A and B to the last empty row, then paste only values it in from cell A1 in sheet named "NEW"

Next
In "AAA" tab copy entire columns A and B to the last empty row, then paste only values in last empty row in same sheet above named "NEW"

Next select column A from "NEW" tab and remove duplicates

Next select column b from "NEW" tab and remove duplicates

Next if entire cell contents in column A or B contain exact match " | | " or " | " then delete that cell and shift cells up so there is no empty cell
I want to achieve this without the screen flickering and would like it to happen in the background while on current tab

Please advise how to create an awesome button that will achieve this

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...uirements-button-post5066924.html#post5066924

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.