Hi Guys, I am building a risk assessment form and need some help from the experts :D First would like the table to automatically add number in sequence if the cell risk is not blank as per table below. The same applies for mitigation and additional mitigation but with difference that information from risk number should be used. 1 RISK 1 1.1 Mitigation1 1.1.1 Additional mitigation1 1.2 Mitigation 2 1.1.2 Additional Mitigation 2 2 Risk 2 2.1 Mitigation 1 2.1.1 Additional mitigation1 Finally, i need that every time risk is inserted that the Top border of entire table is drawn for all 8 cells. Many thanks for all your help and suggestions. Best Regards, Djordje Pantovic

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Auto formatting excel sheet using VBA

Thread starter djolemomaq
Start date Mar 4, 2021
Tags

excel & countifs formatting vba

djolemomaq

New Member

Mar 4, 2021

Hi Guys,

I am building a risk assessment form and need some help from the experts :D

First would like the table to automatically add number in sequence if the cell risk is not blank as per table below. The same applies for mitigation and additional mitigation but with difference that information from risk number should be used.

1	RISK 1	1.1	Mitigation1	1.1.1	Additional mitigation1
		1.2	Mitigation 2	1.1.2	Additional Mitigation 2

2	Risk 2	2.1	Mitigation 1	2.1.1	Additional mitigation1

Finally, i need that every time risk is inserted that the Top border of entire table is drawn for all 8 cells.

Many thanks for all your help and suggestions.

Best Regards,
Djordje Pantovic