I am getting to the point now with a Change Management Tracker I have been developing to roll it out for a small number of people to work with.
In development I took the following approach
I use a few number of rows to represent each change type and its assocaited criteria in terms of task make up. I have appled the relevant formula and conditional formatting to these Sample Rows and Columns.
I have then Identified a further 10 active rows for my colleagues to enter their data to stress test the worksheet.
I am at the point of checking my sample rows before I copy to the 10 rows my colleagues will work with.
After this my plan is to populate a futher 500 rows with the formula and formatting.
Before I go ahead with this I was wondering is there a Quality Assurance approach to checking/auditing the Formula and Formatting works once copied to a large range of cells ahead of me rolling
Thank you in advance.
Best Regards
Marcie Be
In development I took the following approach
I use a few number of rows to represent each change type and its assocaited criteria in terms of task make up. I have appled the relevant formula and conditional formatting to these Sample Rows and Columns.
I have then Identified a further 10 active rows for my colleagues to enter their data to stress test the worksheet.
I am at the point of checking my sample rows before I copy to the 10 rows my colleagues will work with.
After this my plan is to populate a futher 500 rows with the formula and formatting.
Before I go ahead with this I was wondering is there a Quality Assurance approach to checking/auditing the Formula and Formatting works once copied to a large range of cells ahead of me rolling
Thank you in advance.
Best Regards
Marcie Be