Macro script for excel activity

Help Activities
1

Need to set a condition in excel
If one column is filled another also need to be filled and vice versa
If not filled then need to get a message in excel while saving or closing

2

@Demo_User do you want VBA Macro Script?

3

Yes, I want VBA macro script

4

@Demo_User Can you elaborate more

5

I have column A column B
If column A is filled B should be filled
If column B is filled A should be filled
If both is blank then no issues

If A is filled and Without filling B if saving the file and closing that time it should give a pop up like
Please find the mandatory B column

And vice versa
If B is filled and Without filling A if saving the file and closing that time it should give a pop up like
Please find the mandatory A column

If both is blank then no need to do anything

1 Like