+ Reply to Thread
Results 1 to 3 of 3

Automatically adding new row on top of existing data

  1. 08-28-2015, 11:25 PM #1
    RyanEAS
    RyanEAS is offline
    Registered User
    Join Date
    03-06-2012
    Location
    Evansville, IN
    MS-Off Ver
    Excel 2003
    Posts
    9

    Automatically adding new row on top of existing data

    So I have 90 days worth of rows with values I'm tracking on a daily basis. Is there a way to have a new row automatically added each day ON THE TOP of all the existing rows? I know I could just go in and insert a row. However I want the oldest data (which would be on the bottom) to automatically drop-off after 90 days. So basically each day it's adding a new one and discarding the oldest. I've attached the file for reference. Any and all help would be much obliged!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-29-2015, 01:22 AM #2
    RyanEAS
    RyanEAS is offline
    Registered User
    Join Date
    03-06-2012
    Location
    Evansville, IN
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Automatically adding new row on top of existing data

    Solved!!! Thanks anyway!
    Reply With QuoteRegister To Reply
  3. 08-29-2015, 01:49 AM #3
    AceCo55
    AceCo55 is offline
    Registered User
    Join Date
    06-07-2013
    Location
    South Australia
    MS-Off Ver
    Excel 2016
    Posts
    21

    Re: Automatically adding new row on top of existing data

    Would you mind sharing how you did this?
    Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding data to an existing spreadsheet
    By clarkey10 in forum Excel General
    Replies: 3
    Last Post: 04-27-2015, 04:00 PM
  2. searching for and adding data to existing row
    By mezzle992 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-01-2014, 09:47 PM
  3. [SOLVED] Automatically Adding a IF Statement To A Column Of Existing Formula's
    By GEANZ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2013, 12:50 AM
  4. Adding Data to an existing worksheet
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2010, 11:09 PM
  5. adding data over existing chart
    By Diesel13 in forum Excel General
    Replies: 1
    Last Post: 03-04-2010, 10:30 AM
  6. Automatically adding new worsheets to existing sums
    By scaffdog845 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2008, 02:07 PM
  7. Adding data to existing lines.
    By tvdinner in forum Excel General
    Replies: 4
    Last Post: 11-01-2006, 03:11 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1