taisweb
asked on
I need to change a cells value if a corresponding value is found in a seperate worksheet. I don't know how.
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?
sampledata.xls
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?
sampledata.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
David