+ Reply to Thread
Results 1 to 2 of 2

Refresh Subtotal's Button

Hybrid View

  1. #1
    Registered User
    Join Date
    08-20-2007
    Posts
    4

    Refresh Subtotal's Button

    I have never used macro's or placed buttons in excel before. What I am attempting to do is have subtotals automatically refresh when new data is inputted into my data entry sheet, since I cannot get it to do that I am hoping someone can direct me to a good source to make a Button that when clicked will just refresh the subtotals of the data.

    As of current the subtotals don't refresh, they just keep the same cell references when new data is entered and don't sort properly. I have to manually go to Data, then Subtotals and re-run the subtotals, since what I am working on is for an external user I would like a way for it to do it for them or have a simple button for them to click.

    Any help would be greatly appreciated.

  2. #2
    Registered User
    Join Date
    08-20-2007
    Posts
    4
    Problem Solved. I figured out a better way to do what I was attempting to do. Thanks though.

+ 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