I am relatively new to VBA and I am trying to create an array to compare columns in a worksheet. for example, I want to look through a column with unknown rows and every time I find the word "AUTH" I want to then look at its value which is in another column and paste it to an empy tolumn in the same row.

Another example is I want to look at more than one column and compare them. Ex) if row says "AUTH" and then another column (same row) says "CANCELLED" then again return value found in another column to blank column.


Thank you for your help. I hope this isnt completely confusing. I guess i am just having a lot of trouble understanding how to compare arrays or even set them up to be compared.