mandatory complete other cells if one cell is compleated

[Bogdanmartin1988]

Hello,

i want to do the next move:

For example: When (cell A2) is completed , mandatory have to complet cells A2, G2 , I2 and so on and if all cells are not completed you cannot save and you get a message (Ex. you have to fill A2 ,G2,I2).

And if cell A2 si not completed do nothing, should work only when you start to write in A2

can someone please help me with this issue?(maybe with a VBA code)

[spitfireblue]

Hi,

I believe that you need something like this that runs the check when you try to save the workbook.

Please Login or Register  to view this content.

Book1.xlsm

Best of luck,
Stephen

[Bogdanmartin1988]

thank you verry much , its working but i have still a problem.

first i explain you what is with this excel
more users have to complete this sheet but some user starts to complete but not finishes, and they save it incomplet.
i want the code working when a user starts to complete in a new row (ex . if cells A3:A400 are filled automatically the VBA code works but if Cells A3:A400 are empty nothing have to happens - the code should work just when they start to write in cells A3:A400)

Thank you

[spitfireblue]

Ok... so this will start at A2 and will continue down column A until it finds a blank, checking to ensure the matching cells in G & I have a value.

Please Login or Register  to view this content.

You may want to replace the first "Set cell = cell.Offset(1, 0)" with "Exit Sub" to exit if it finds one error.

Stephen

[Bogdanmartin1988]

hello,

please see attached(an print screen) of what i'm trying to do


When an user fill the cell "B2" is mandatory for him to fill the next cells( E2, F2 , I2 and M2 - if this cells are not filled ,when it saves gives an error) and if the other cells remain empty is not a problem.

and this rule must apply for everyone that starts to fill first cell(B2 , 3,4,5...) but just when is filled, if not filed nothing should happens


can someone please help me?

Thank you!

[spitfireblue]

Hi,
I think this is the code that you need.

Please Login or Register  to view this content.

Let me know if you have any issues.
Stephen

[Bogdanmartin1988]

Yes ,it's working
thank you very much for help!

[spitfireblue]

No problem

[Bogdanmartin1988]

one more thing

it is posible ,for example if F2 and M2 or just one of thiss cells are not filled ,when you got the message (error) to show exactly what cell or cells are not filled?

Thank you and that's it :D

[spitfireblue]

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.