We have a workbook in which we need to copy only the required data to sheet "CP + Party" from sheet Raw Data,
1. First in Raw Data sheet apply filter in column D as contains "Fender" or "JBL" or "SANTIAGO" copy the data (Column A to E) to next sheet by name "CP + Party" paste starting row 2.
2. Secondly in Raw Data sheet apply filter in column E as contains "Fender" or "JBL" or "SANTIAGO" copy the data (Column A to E) to next sheet by name "CP + Party", paste below the previously pasted data.
I have a recorded macro (recorded on relative mode), however iam getting an error with this, please help needed to build this in a better and consistent way or suggest. Attached sample workbook.
1. First in Raw Data sheet apply filter in column D as contains "Fender" or "JBL" or "SANTIAGO" copy the data (Column A to E) to next sheet by name "CP + Party" paste starting row 2.
2. Secondly in Raw Data sheet apply filter in column E as contains "Fender" or "JBL" or "SANTIAGO" copy the data (Column A to E) to next sheet by name "CP + Party", paste below the previously pasted data.
I have a recorded macro (recorded on relative mode), however iam getting an error with this, please help needed to build this in a better and consistent way or suggest. Attached sample workbook.