Hi there,
I would like to seek for your help on the macro coding that currently stuck at... Appreciate your help.
Information
Sheet 1 - to use Sheet 2 data and check if there is any match in column A
Sheet 2 - There is only formula in column F, which was auto pasted from the previous coding after filtered (so the table in this sheet is in filtered
We need to check if the data in Sheet 2, column F matches with the data in Sheet 1, column A.
2 criteria to check & match.
First one is the number obtained from the formula will exactly matched in column A (Sheet 1)
The second one is if * & column E (Sheet 2) is matched with the column A (Sheet 1)
Then no action.
If there is any unmatched, then we will highlight that number in column F (Sheet 2).
Thank you in advanced for looking into it.
I would like to seek for your help on the macro coding that currently stuck at... Appreciate your help.
Information
Sheet 1 - to use Sheet 2 data and check if there is any match in column A
Sheet 2 - There is only formula in column F, which was auto pasted from the previous coding after filtered (so the table in this sheet is in filtered
We need to check if the data in Sheet 2, column F matches with the data in Sheet 1, column A.
2 criteria to check & match.
First one is the number obtained from the formula will exactly matched in column A (Sheet 1)
The second one is if * & column E (Sheet 2) is matched with the column A (Sheet 1)
Then no action.
If there is any unmatched, then we will highlight that number in column F (Sheet 2).
Thank you in advanced for looking into it.