mycelium
06-22-2019, 09:05 PM
Hi,
I need help to create a vba function that helps to match data.
I got a string that contains invoice no, company name, type and date.
I need to create a function to match the string with a list of invoice no. from a column in another sheet.
If the string and invoice no. are matched, it will then proceed to match the company name, type and date from the same row as the invoice no.
The box will turn green if the information matches the string
The box will turn red if the information does not match the string
An example of the result. 24474
Thank you
I need help to create a vba function that helps to match data.
I got a string that contains invoice no, company name, type and date.
I need to create a function to match the string with a list of invoice no. from a column in another sheet.
If the string and invoice no. are matched, it will then proceed to match the company name, type and date from the same row as the invoice no.
The box will turn green if the information matches the string
The box will turn red if the information does not match the string
An example of the result. 24474
Thank you