I am trying to write code that would enter data into a cell based upon how the name of the worksheet ends.
E.g.:
If Worksheet name end with 123 then enter "ABC" into A1, otherwise enter "XYZ"
I have been trying to do this simple thing in all different kinds of ways, but so far no luck.
Can anyone please help me in my misery?
Thanks.
JPM
E.g.:
If Worksheet name end with 123 then enter "ABC" into A1, otherwise enter "XYZ"
I have been trying to do this simple thing in all different kinds of ways, but so far no luck.
Can anyone please help me in my misery?
Thanks.
JPM