PDA

View Full Version : Copy paste with VBA



tyrese215
05-31-2018, 09:41 PM
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

p45cal
06-01-2018, 04:17 AM
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.