Hello, I am trying to fill column A with either Lost(Breach) or Update(Breach) based on the name of the worksheet. One thing to note is that the worksheets are all of the same names, so they are all labelled as Lost (Breached)(Number) and Update(Breached)(Number) so I can't really fill the columns of all the worksheets that I need
Is there like a string or variable VBA that i can tie the keywords "Lost" and "Updates" to so that the code will just reference either one of these 2 keywords and fill Column A with the words that i want it to? And how do i go about coding it?
Thank you!
Is there like a string or variable VBA that i can tie the keywords "Lost" and "Updates" to so that the code will just reference either one of these 2 keywords and fill Column A with the words that i want it to? And how do i go about coding it?
Thank you!