sanantonio
Board Regular
- Joined
- Oct 26, 2021
- Messages
- 124
- Office Version
- 365
- Platform
- Windows
Hi,
So I have a base data field.
Then I need a vba code that will check whether any of these items (They will be in alternate columns D,G, etc. the length will vary but it wouldn't hurt if it had to search through any blank columns) are NOT on a status 9. This is determined by looking up into a second data field:
Then return a message box if it finds ANY item that is NOT on status 9, and then run a macro if all of them are on status 9.
And then extra, conditionally format any items that aren't on 9.
Any suggestions? I've been fumbling around for a while this weekend trying to figure the best way of doing this. Any help would be appreciated.
So I have a base data field.
Then I need a vba code that will check whether any of these items (They will be in alternate columns D,G, etc. the length will vary but it wouldn't hurt if it had to search through any blank columns) are NOT on a status 9. This is determined by looking up into a second data field:
Then return a message box if it finds ANY item that is NOT on status 9, and then run a macro if all of them are on status 9.
And then extra, conditionally format any items that aren't on 9.
Any suggestions? I've been fumbling around for a while this weekend trying to figure the best way of doing this. Any help would be appreciated.