S
Suzie
Hi, I wonder if anyone would be kind to explain to me how I would make a
macro do the following:
I need to make a keyboard shortcut of Ctrl A to insert a new line on Row C12
whenever a new line is required. My formula in D5 is the average of the 5
most recent values from c12.c16, my formula in D3 is the total average of
all values c12..c#. So my macro has to insert the new row but still fix the
formulas and labels and prevent anyone from changing anything else expect
the information they are inputting in Row12. So the macro needs to
unprotect the worksheet, do all the required tasks then re-protect it whilst
still allowing access to row 12.
Sorry it sounds a bit of a muddle, but this stuff does that to me - lol
I have detailed my worksheet below and any help would be very much
appreciated. Suzie
CLIENT FEEDBACK / EVALUATIONS
To add a new evaluation Overall Evaluation 2.5 Quick Assessment
Press Ctrl+A
Recent Evaluations 2.5 Poor-Improving
To add a new operator
Select File New and CCRU_Summary Workbook Quick Review
The File Save As using the operators name as the filename Poor -
Improving
COMPANY NAME CALLER NAME EVALUATION RELEVANT COMMENTS
Don't Use this Line
1
2
3
4
Overall Evaluation 2.5
macro do the following:
I need to make a keyboard shortcut of Ctrl A to insert a new line on Row C12
whenever a new line is required. My formula in D5 is the average of the 5
most recent values from c12.c16, my formula in D3 is the total average of
all values c12..c#. So my macro has to insert the new row but still fix the
formulas and labels and prevent anyone from changing anything else expect
the information they are inputting in Row12. So the macro needs to
unprotect the worksheet, do all the required tasks then re-protect it whilst
still allowing access to row 12.
Sorry it sounds a bit of a muddle, but this stuff does that to me - lol
I have detailed my worksheet below and any help would be very much
appreciated. Suzie
CLIENT FEEDBACK / EVALUATIONS
To add a new evaluation Overall Evaluation 2.5 Quick Assessment
Press Ctrl+A
Recent Evaluations 2.5 Poor-Improving
To add a new operator
Select File New and CCRU_Summary Workbook Quick Review
The File Save As using the operators name as the filename Poor -
Improving
COMPANY NAME CALLER NAME EVALUATION RELEVANT COMMENTS
Don't Use this Line
1
2
3
4
Overall Evaluation 2.5