I’m looking to figure out an automation process for an excel file I have, using VBA code. I’m fairly new to VBA coding, and my last few attempts have been unsuccessful. I was hoping I could possibly find some guidance on the subject?
There are multiple sheets within the excel file, but all work will be done via the ‘Activesheet’ for ease of use. There are over 800 rows that this code would have to run through, so it needs to be some sort of loop. I would prefer to have declared variables, but any solution is appreciated!
Please help if possible, and let me know if I need to provide any more information for a proper diagnosis. Thanks!
Example of structure (in my mind):
If Column A contains “TextA” Then __
Column D will contain “TextA”
ElseIf Column A contains “Text B” Then _
Column D will contain “Text C”
ElseIf Column A contains Nothing Then_
Column A will now contain “Null” in Bold Red font
Next Loop (next row)