-
Copy paste with VBA
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
-
Prepare a little workbook with sheets AAA, BBB and NEW.
Put some typical data in AAA and BBB.
Then add another sheet that shows the results you expect to see in NEW after the button is clicked.
Attach that workbook here.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules