Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.
Please attach your excel file here .I will send you back with the modification you need in it.
Yes, It will be visible even when you print it.
If you are facing any problem in attaching it here then you can upload it to dropbox, Google Drive etc and send me its link.
Yes, I am working on it. I will get back to you as soon as I am done with it. It is bit tricky as we have freeze top row as well
I tried many things but both bottom and top frames can not be freezes at a time so now what we can do is either we display total in the first row as well using a formula or we can add watch window to you excel file. With watch window , Print option won't work.
Just a min, I am sending you a sheet.
This is how it will be visible in your sheet.
In this file , I have added watch window at the bottom, It will be visible always and it's value will change as soon as the value of total changes but you won't be able to print it.
Not sure, Why I am not able to send you the file properly. Let me rename it and try again.
Yes, I have already sent it to you.
If you want me to do it in your other original file then I can do it as well really quick or else if you want me to do it in front of you then I can remotely connect to your machine and do it.
Ok, Got you. So you are sending me original file or you want me to connect to your computer ?
I am sending you small offer so that I can securely send your file back to you using drop box.
I think it is same(file which you have sent to me recently) . Please check and confirm.
ok. I am on stand by
Oh. Okay,If you don't want to avail that then it's okay. I was just thinking that you may have some confidential data in it and you don't want others to see it that's why I though of sending you that offer. Generally, With most of my customers,I go with that option.
Just a min, I am sending you a file.
Here is the file.
Please provide your rating to me as well. As we have worked together for the first time that's why may be you could not get my intention.
I am awaiting your rating now.
Click on enable editing and then scroll the watch window to right side till you see Total in it.
Did you get it ?
I think, It automatically pop's up on the screen when we open the sheet for the first time. Are you able to edit the sheet which I have sent to you ?
In the mean time , It would be great to get a rating from you. Your rating means a lot to me and will always motivate me to give extra efforts on this issue.
Not sure why but I can see it on the file which I have share with you. It been a long long time on this issue.
I think I should not continue with you anymore. You have been very harsh throughout and it is very disappointing. I think I have wasted my time working with you.
I know so people does this intentional when they do not want to pay.
Treat whatever I have done here as a free service and enjoy your rest of the day. I am opting out. Good BYE