Need Help to creating macros
I have to COPY/paste items in column A of sheet 1 (primary sheet) recieved daily
Trying to acheive the following using macros
-To check and Delete column A(PASTED ITEMS) SHEET 1 (anything after "-" example - "Apple-bad" to show as "Apple")
-To check and delete duplicates from column A sheet 1 of pasted items(example:If item Apple exist in both Column A: Row1 and ColumnA : Row6 TO DELETE 1
item)
-To check in sheet 2 and if any match in column A of (sheet 2),Put it as "MATCHED" in column C of sheet 1
- When items copied/pasted in column A of sheet 1 ,To check/compare in sheet 3 predefined items in column F ,column J and COLUMN S and copy matched items in
Column E, column F and Column G respectively in SHEET 1
-Next delete complete row from column G from sheet 1 which says "EOL"
-Highlight SHEET 1 and Sort column F of sheet 1 in ascending(A-Z)
-Highlight sheet to ARIAL 11
Finally to compare data from sheet 4 column A when data is pasted in sheet 1 column and One pop up message appears " Apples and applesB matched and Orange
and orangeB matched" if any match found.
I have to COPY/paste items in column A of sheet 1 (primary sheet) recieved daily
Trying to acheive the following using macros
-To check and Delete column A(PASTED ITEMS) SHEET 1 (anything after "-" example - "Apple-bad" to show as "Apple")
-To check and delete duplicates from column A sheet 1 of pasted items(example:If item Apple exist in both Column A: Row1 and ColumnA : Row6 TO DELETE 1
item)
-To check in sheet 2 and if any match in column A of (sheet 2),Put it as "MATCHED" in column C of sheet 1
- When items copied/pasted in column A of sheet 1 ,To check/compare in sheet 3 predefined items in column F ,column J and COLUMN S and copy matched items in
Column E, column F and Column G respectively in SHEET 1
-Next delete complete row from column G from sheet 1 which says "EOL"
-Highlight SHEET 1 and Sort column F of sheet 1 in ascending(A-Z)
-Highlight sheet to ARIAL 11
Finally to compare data from sheet 4 column A when data is pasted in sheet 1 column and One pop up message appears " Apples and applesB matched and Orange
and orangeB matched" if any match found.