I have a report due monthly that depends on the values found in several worksheets.
DomainList: includes all domains and domain aliases in the account.
AliasList: is a filtered list of just the domain aliases.
In the report I have a column titled Type which can have a value of either "S" or "A" depending on if it is a site or an alias.
Type is determined by finding a domain name in the alias list (or not).
I think the question I need to ask is:
If "DomainList:domainname" is found in AliasList:domainname then type = "A"
If "DomainList:domainname" is NOT found in AliasList:domainname then type = "S"
How do I do this in VBA?