Hi
I have a worksheet created by a macro. I have made some manual changes to a few of the details on the sheet and would like it to automatically update all the calculations . Is this possible?
Hi
I have a worksheet created by a macro. I have made some manual changes to a few of the details on the sheet and would like it to automatically update all the calculations . Is this possible?
Hello TERRI LEE,
On the Ribbon, just set Calcultion to Automatic.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi
It is set to automatic but if I delete a number the subtotal rows are not updated
Very strange
Could you perhaps upload a sample Workbook with your Code, for us to have a look at?
Hi the sheet attached is the product of the above macro that runs on another work book. I wanted to manually delete some numbers and modify others within this work book and I then need it to automatically recalculate all the formula. I have another post with this macro in where I have asked for help with the grand totals row as it is not adding up correctly along with a few other formating issues.Please Login or Register to view this content.
Last edited by TERRI LEE; 12-15-2012 at 05:51 AM.
Thank you, I have checked the Book and it works fine on my side. If I delete a number in any of the Sub-Total Ranges, it updates as it should.if I delete a number the subtotal rows are not updated
Is there a specific Column or Row you have a problem with?
Hi
I wanted to delete for example D1400 which should update the subtotal and then the grand Total
Hello TERRI LEE,
That also works without any problem on my side. Check out the very same workbook you had sent me, and see if it is working.
Hi
You are right so I have no idea why it is not working in my other schedule.
Thanks any way.
Try to place,
in your code and see if it makes any difference.Please Login or Register to view this content.
I already have this in the macro excepting where you got false i have true
Sorry, I should have mentioned, to place it at the top of your Code.
Okay I will try that. I have changed the work book in post 5 so look at that one please. If clear a cell it needs to update column k in order for my other calculations to be correct.
Nope that also does not work but i changed the formula in the macro for column K and now it is working. I am slowly but surely getting this macro thing figured out. I need help with my totals row please see if you can help me here.
Thanks Terri
Could you be more specific about what kind of help?I need help with my totals row please see if you can help me here
Thanks for your help
Last edited by TERRI LEE; 12-15-2012 at 03:20 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks