+ Reply to Thread
Results 1 to 16 of 16

Macro created worksheet - how to update manual changes

  1. #1
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Macro created worksheet - how to update manual changes

    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?

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: Macro created worksheet - how to update manual changes

    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] .

  3. #3
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Macro created worksheet - how to update manual changes

    Hi

    It is set to automatic but if I delete a number the subtotal rows are not updated

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: Macro created worksheet - how to update manual changes

    Very strange

    Could you perhaps upload a sample Workbook with your Code, for us to have a look at?

  5. #5
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Macro created worksheet - how to update manual changes

    Please Login or Register  to view this content.
    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.
    Attached Files Attached Files
    Last edited by TERRI LEE; 12-15-2012 at 05:51 AM.

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: Macro created worksheet - how to update manual changes

    if I delete a number the subtotal rows are not updated
    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.

    Is there a specific Column or Row you have a problem with?

  7. #7
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Macro created worksheet - how to update manual changes

    Hi

    I wanted to delete for example D1400 which should update the subtotal and then the grand Total

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: Macro created worksheet - how to update manual changes

    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.

  9. #9
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Macro created worksheet - how to update manual changes

    Hi

    You are right so I have no idea why it is not working in my other schedule.

    Thanks any way.

  10. #10
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: Macro created worksheet - how to update manual changes

    Try to place,

    Please Login or Register  to view this content.
    in your code and see if it makes any difference.

  11. #11
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Macro created worksheet - how to update manual changes

    I already have this in the macro excepting where you got false i have true

  12. #12
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: Macro created worksheet - how to update manual changes

    Sorry, I should have mentioned, to place it at the top of your Code.

  13. #13
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Macro created worksheet - how to update manual changes

    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.

  14. #14
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Macro created worksheet - how to update manual changes

    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

  15. #15
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: Macro created worksheet - how to update manual changes

    I need help with my totals row please see if you can help me here
    Could you be more specific about what kind of help?

  16. #16
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Macro created worksheet - how to update manual changes

    Thanks for your help
    Last edited by TERRI LEE; 12-15-2012 at 03:20 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1