+ Reply to Thread
Results 1 to 9 of 9

if statement to collect data per day without overriding

  1. #1
    Registered User
    Join Date
    10-05-2021
    Location
    Leicester
    MS-Off Ver
    2013
    Posts
    76

    if statement to collect data per day without overriding

    I'd like to populate a sheet daily from the same single cell which contains a "countif" statement from another data source and changes data daily.

    So i have a column of dates in A:A and blank data in B:B. On sheet2 in X1 is the data required. So the If statement would be in B1 .... =if(A:A = today() then add X1... But then when it comes to the next day my previous data will be false and wiped just adding the next day.

    Is there a way of saying When it is today add this data and then save the data over the formula ? or is there an easier solution I'm missing here ?

  2. #2
    Valued Forum Contributor
    Join Date
    07-23-2013
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    864

    Re: if statement to collect data per day without overriding

    I'm not quite clear what you require, would you please be able to upload a sample workbook with expected results? There should be instructions in the yellow box at the top of the page.

  3. #3
    Registered User
    Join Date
    10-05-2021
    Location
    Leicester
    MS-Off Ver
    2013
    Posts
    76

    Re: if statement to collect data per day without overriding

    added example sheet
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,813

    Re: if statement to collect data per day without overriding

    If you want Excel to "remember" what was in a cell before the data were overwritten... you can NOT do this with a formula. You will need VBA. If that is OK, I will move the thread for you.
    Glenn



  5. #5
    Valued Forum Contributor
    Join Date
    07-23-2013
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    864

    Re: if statement to collect data per day without overriding

    I'm still not really sure what you want it to do, but agree with Glenn that it sounds like you probably need a VBA solution.

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,299

    Re: if statement to collect data per day without overriding

    Even with VBA you may not be able to use the (typical) "Worksheet_Change" approach [as all the data you highlight are is created via formula] unless it can be triggered by entries in columns P:S on Sheet2.

    If you want to go VBA (no alternative!) then post a workbook with an EXACT representation of your real file (I hope Sheet2 is a "sample" only!).
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  7. #7
    Registered User
    Join Date
    10-05-2021
    Location
    Leicester
    MS-Off Ver
    2013
    Posts
    76

    Re: if statement to collect data per day without overriding

    Thanks i will post in VBA

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,813

    Re: if statement to collect data per day without overriding

    NO. I will move the thread.

  9. #9
    Valued Forum Contributor
    Join Date
    07-23-2013
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    864

    Re: if statement to collect data per day without overriding

    What do you want the macro to do? Copy the data in C12:D12 on Sheet2 and paste to column B and C in Sheet1, for the row that corresponds to today's date? Where do you want to run it from, Sheet1 or Sheet2?

+ 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. Formula "either, or" With an overriding statement
    By pronator in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-07-2016, 06:11 PM
  2. Copy/Paste Overriding Data Validation
    By runnerD2016 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2016, 12:01 PM
  3. VBA to collect data
    By Macca_GB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2015, 01:12 PM
  4. Replies: 0
    Last Post: 02-04-2013, 06:59 PM
  5. help with collect data
    By 400396 in forum Excel General
    Replies: 2
    Last Post: 07-28-2012, 11:22 AM
  6. Collect data from other tab
    By saslotteroy in forum Excel General
    Replies: 3
    Last Post: 10-16-2011, 04:25 PM
  7. Excel 2007 : Formula Overriding Data Validation
    By MacroMartin in forum Excel General
    Replies: 7
    Last Post: 08-10-2009, 04:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1