Need help in programming macro for form submission

Hi,

I have this call monitoring sheet we use at work and it gets tedious to maintain multiple sheets for our employee's calls's, my boss wants me to get a macro coded in this to submit the data to a different sheet once the button is clicked and also update the call status as per a set criteria.

The call grading criteria is as below

Red= 50 & below
Amber= 51 to 80 scoring
Green= 81 & above

I have no clue on how to do this and need help.

Regards,

Sanmeet

This might help to your macro project.

https://www.excelforum.com/excel-pro...rform-vba.html

Hi.

I'm sure it would help me if I understood what the code does, from what I understood reading the text,this code is for copying data on basis of checkboxes
My requirement is quite different from it.

I need all data to be transposed to the data sheet under the appropriate headers when submit is clicked.

Regards,

Sanmeet

alright will try my best to work on your request

Hi

Try attached file.

Thanks

any update?

Apologies for the dealy, yes it works however the entries are happening in row 600 onwards and not from row 3 above

Also if you can help checking this formula its supposed to go in the subtotal field of the form and if the answer to any of the questions above is N/A the score should not get changed or effected in any way.

However when I choose N/A the score gets added to the subtotal and it should not happen

=SUMIF(G16:G26,"Yes",$E16:$E26)/(1-SUMIF(G16:G26,"N/A",$E16:$E26)/SUM($E16:$E26))*IF(COUNTIFS($F16:$F26,"auto zero",G16:G26,"No"),0,1)

The autozero part of the formula can be removed as we've decided not to use it.

yeah thanks for catching that one, because there is a value in Call total that is why the next empty value is under that column which is 600+. will try to update the file.

If needed we can remove the values in the cell total column if that helps I can always add the formula there later

Thank you for fixing the Macro can you now help me with that formula I sent earlier?

Also if you can help checking this formula its supposed to go in the subtotal field of the form and if the answer to any of the questions above is N/A the score should not get changed or effected in any way.

However when I choose N/A the score gets added to the subtotal and it should not happen

=SUMIF(G16:G26,"Yes",$E16:$E26)/(1-SUMIF(G16:G26,"N/A",$E16:$E26)/SUM($E16:$E26))*IF(COUNTIFS($F16:$F26,"auto zero",G16:G26,"No"),0,1)

The autozero part of the formula can be removed as we've decided not to use it.

Originally Posted by sssanmeet

Thank you for fixing the Macro can you now help me with that formula I sent earlier?

Also if you can help checking this formula its supposed to go in the subtotal field of the form and if the answer to any of the questions above is N/A the score should not get changed or effected in any way.

However when I choose N/A the score gets added to the subtotal and it should not happen

=SUMIF(G16:G26,"Yes",$E16:$E26)/(1-SUMIF(G16:G26,"N/A",$E16:$E26)/SUM($E16:$E26))*IF(COUNTIFS($F16:$F26,"auto zero",G16:G26,"No"),0,1)

The autozero part of the formula can be removed as we've decided not to use it.

Any help with the above?