+ Reply to Thread
Results 1 to 1 of 1

Dynamic values by date

  1. #1
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Cologne, Germany
    MS-Off Ver
    Excel 2010
    Posts
    156

    Question Dynamic values by date

    I have an interesting problem that I fear can only be solved with VBA. If anyone has any ideas otherwise, Iíll be very glad to see them!
    I have one cell with a numeric value that is updated throughout the day. At the end of the day, whatever the final value, it is manually input into a list as per the example attached. Is there a way of recording the daily values into the list without doing so manually? Obviously a lookup formula alone wonít do it as every day will have the same value or alternatively only the current dayís value will show. It would be great to have a formula that records the daily values and transfers each value to the list by date and leaves the value there when the date changes to the following day.
    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. [SOLVED] Dynamic named range based on a start date and end date
    By Gary Lockton in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-06-2012, 07:26 PM
  2. Summing values based on a dynamic date range
    By welchs101 in forum Excel General
    Replies: 2
    Last Post: 09-27-2011, 07:00 PM
  3. Macro to special paste dynamic values into text values with periods
    By iyudhi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2011, 04:42 PM
  4. Manipulate dynamic rows values and dynamic columns values
    By excel_vb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2010, 09:22 PM
  5. Replies: 0
    Last Post: 08-29-2005, 07:45 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