+ Reply to Thread
Results 1 to 10 of 10

In a nutshell, I知 trying to store/save a daily increasing value by date...

  1. #1
    Registered User
    Join Date
    04-09-2017
    Location
    Texas
    MS-Off Ver
    2003
    Posts
    4

    In a nutshell, I知 trying to store/save a daily increasing value by date...

    Hello All,
    Being new to Excel & self taught to this point, it’s been helpful to find this site & browse. I haven’t had any luck using search for my problem. I’m using a really old version of Excel (Office Excel 2003 SP3)/Win-XP & that might be a problem with the advice I need. I’ve just been entering the number by hand, then I spent hours that turned into days trying to figure a way to do this. Now it’s turned into a Crusade. I humbly ask the Excel Guru’s for advice or tell me that it’s not gonna happen & put me out of my misery

    In a nutshell, I’m trying to store/save a daily increasing value ($A$3) into Col. $C, line [which ever corresponds with =TODAY()(A1) date line (A10:A14 for example).]

    TIA for any advice/suggestions…
    4bits

    *** Reloaded workbook w/o password... sorry! ***
    Attached Files Attached Files
    Last edited by 4bits; 04-14-2017 at 07:47 PM.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: In a nutshell, I知 trying to store/save a daily increasing value by date...

    Umm...need the password.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: In a nutshell, I知 trying to store/save a daily increasing value by date...

    =IF(AND(A13=$A$1,$A$3>C12),A3,"") put in c13 and copy down

  4. #4
    Registered User
    Join Date
    04-09-2017
    Location
    Texas
    MS-Off Ver
    2003
    Posts
    4

    Re: In a nutshell, I知 trying to store/save a daily increasing value by date...

    Jamesera27, Thank you for your suggestion.

    After pasting your formula into C13:C14, when I change A1 to 4/15 & increase A3, C13 gives the correct answer that = A3. Then when I change A1 to 4/16 & increase A3, C13 vanishes & C14 remains blank.

    I’ve not been able to keep the values in the C column either.
    4bits

  5. #5
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: In a nutshell, I知 trying to store/save a daily increasing value by date...

    Looks like you'll need VBA for this. I'll work on it later...early day tomorrow.

  6. #6
    Registered User
    Join Date
    04-09-2017
    Location
    Texas
    MS-Off Ver
    2003
    Posts
    4

    Re: In a nutshell, I知 trying to store/save a daily increasing value by date...

    Thanks, I'll try to keep up!

  7. #7
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: In a nutshell, I知 trying to store/save a daily increasing value by date...

    Please Login or Register  to view this content.

    try this in a worksheet event...not the prettiest but it should work..you'll probably want it to be a workbook calculate event to auto update. check it out to see if it's what you need. If A3 is a formula, remember to only paste the value... idon't think it will autoupdate when the formula updates...it will if you manually update A3. maybe some of the experts can help
    Last edited by Jamesera27; 04-15-2017 at 12:15 AM.

  8. #8
    Registered User
    Join Date
    04-09-2017
    Location
    Texas
    MS-Off Ver
    2003
    Posts
    4

    Re: In a nutshell, I知 trying to store/save a daily increasing value by date...

    I really appreciate you help. That reply just jumped past my understanding/ability. Thank you for the time you spent with this.
    4bits

  9. #9
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: In a nutshell, I知 trying to store/save a daily increasing value by date...

    Okay, so you said that you're days total comes from another sheet. I inserted another sheet and highlighted a range in yellow. When you enter a number in that range, it will trigger a worksheet change event which calls the update sheet macro. This macro look for the days current date in a10:a400. If it matches the date in A1 it will copy the number from A3 into the appropriate cell. Everything seems to be working fine except any cell on sheet 2 triggers the event. I'm sure that can be fixed. The code is not the best looking in the world but I am also learning myself..self taught. Don't forget to make sheet one cell A1 a formula again, =Today(). Try it out and see what happens
    Attached Files Attached Files
    Last edited by Jamesera27; 04-15-2017 at 12:46 PM.

  10. #10
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: In a nutshell, I知 trying to store/save a daily increasing value by date...

    seems ok now
    Attached Files Attached Files

+ 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. Replies: 8
    Last Post: 09-03-2014, 03:33 PM
  2. Need a macro to store daily values in a column
    By plumberef in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2014, 05:14 AM
  3. Replies: 2
    Last Post: 05-03-2013, 07:09 PM
  4. Replies: 1
    Last Post: 02-02-2013, 05:23 PM
  5. Save as with increasing numbers
    By hond in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 05:55 AM
  6. Automatically Save and Copy Values Daily with a Date Stamp
    By cckal in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-10-2010, 05:36 PM
  7. increasing value of cell on save
    By reggie1000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2009, 10:08 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