I have a must requirement that if A1 has data, B1 should be either / or some other user defined text but should never be blank.
This is just an example, I would also like to extend the logic to complete list e.g. from A1 to A25 and so on.
Trying data validation and some macros already discussed in this forum but no luck.
Please help
This is just an example, I would also like to extend the logic to complete list e.g. from A1 to A25 and so on.
Trying data validation and some macros already discussed in this forum but no luck.
Please help