+ Reply to Thread
Results 1 to 2 of 2

Recalculate function in Auction Bid Sums.xlsm‎ obtained from Help Forum

  1. #1
    Registered User
    Join Date
    10-23-2018
    Location
    Fairbanks, Alaska
    MS-Off Ver
    Office 2016
    Posts
    2

    Recalculate function in Auction Bid Sums.xlsm‎ obtained from Help Forum

    I'm a basic excel user who was asked to run an excel spreadsheet for a non-profit live auction that our group runs once a year. I found a spreadsheet with built in macros and pivot table that works perfectly for my use but I cannot figure out how to get it to recalculate Column E and F when values are changed in Columns B and C...?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Recalculate function in Auction Bid Sums.xlsm‎ obtained from Help Forum

    Add the following to your Worksheet_Change event

    Please Login or Register  to view this content.
    If someone has helped you then please add to their Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating an Average of numbers obtained from function
    By imcharliemurphy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-20-2013, 07:13 PM
  2. Finding the highest number in a column that is obtained by a function
    By wallclock in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-16-2013, 06:00 PM
  3. Function won't recalculate
    By RayJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 05:17 PM
  4. Replies: 2
    Last Post: 03-07-2012, 03:16 PM
  5. Replacing #N/A response when obtained in Lookup function
    By CochranConsult in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-26-2006, 11:10 AM
  6. function does not recalculate sum
    By lukiedukie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2005, 06:06 PM
  7. how to get a function to recalculate
    By Pb21 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-02-2005, 10:37 AM

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