Input data then clear cell but save to another cell..Is there a formula for this?!

I want to be able to see the average rating for each employee.. Is there a way to put in the rating from one survey and have it automatically add it another cell and then have it clear the first cell?

Here is an example of what I would like to do:
Say we get 2 surveys with one rating of 5 and one rating of 10... If I input the 5 into cell Q4 and have it automatically put into cell R4 and then it gets deleted from Q4 but saved to R4... and then I can add the rating of 10 to Q4 and it automatically ads it to R4 and clears Q4 and totals R4 to an average of 7.5.

This way, with each new survey I can just input each rating to Q4 and have it cleared for the next rating and then have an average rating of all the surveys in R4... we do not need to keep track of how many ratings we are getting, just the average rating.


I have attached the excel sheet if you would like to take a look at what I am trying to do..

If this is possible could someone please help.. I would really appreciate it!!
Or if anyone has any ideas of an easier way to do this please let me know.

Thank you soo much!
Attached Files Attached Files

Hi

This is all the macro you need:

Please Login or Register  to view this content.

Hello

i pick up this old tread , i have use some of the code, but i dont know how to cange it , i want range column for D and G , se my workbook and a command that run my macro when i hit enter, hope some one can help me