Data not populating from additional ElseIf arguments

[MattEvansC3]

I'm in the process of creating a VBA script to see if a laptop has been discovered by the network in the past 30 days. Different devices are managed by different discovery tools which generate their own reports. The attached sample is the consolidation sheet I created to manage them. I then use this sheet to record who've I've contacted and then advise senior managers about the status of these devices.


The macro I'm having issues with is one that updates the cells with their current status;
If the status is IN INVENTORY its no longer in use and the query is resolved (the Last Audit date is the last change to the asset management database)
I don't report on devices managed by AirWatch, any discovery there is marked as exempt.
If the device has been discovered in the past 30 days using either CMDB, SCCM or InTunes the query is resolved.

Column U should be either blank, "EXEMPT" or "YES"
Column V should have the date it was discovered or the last audit date
Column W should be populated with a note saying where the information came from.


The macro should populate the end columns in the following priority order IN INVENTORY> AirWatch> CMDB>SCCM>InTunes before moving onto the next line.


The following code works for IN INVENTORY, AirWatch and CMDB but won't populate lines where there's a SCCM or InTunes match

My VBA Code is;

Please Login or Register  to view this content.

Any help would be greatly appreciated

-----------
I worked it out, I should have been using AND statements instead of an additional IF statement

Please Login or Register  to view this content.

[Winon]

Hello MattEvansC3,

No Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html