Results 1 to 6 of 6

Count formula after a sheet is auto updated.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Count formula after a sheet is auto updated.

    Hi Folks

    Greetings from a bush fires smoke filled valley

    But to business:

    The attached sheet is auto updated from another program.
    Each update fills new info into row 2 so all other updates are pushed down one.
    I want the Cells in Col G to count the updates as shown ie Cell G2 will always have the highest number.

    Row 2 will be blank before the first update so therefore the first update will be number 1 in G2

    Hope that makes sense.

    Cheers
    Hammer
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto Updated Master Sheet when Other Data Sheet add new data
    By koolguys4u in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-23-2013, 05:36 AM
  2. Auto sort when updated
    By IsiEMT in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-26-2011, 02:00 PM
  3. Replies: 6
    Last Post: 03-05-2010, 08:46 AM
  4. Rev. Auto Updated when sheet is updated and or entire book
    By frankee_gee in forum Excel General
    Replies: 1
    Last Post: 04-07-2008, 05:05 PM
  5. Auto updated chart
    By taleksak in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 10-07-2007, 06:18 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