Forum Discussion

Iank95's avatar
Iank95
Copper Contributor
Nov 19, 2020

Help Needed copy and pasting values only when a condition is met

Hi Everyone,    I have an excel table that tracks the % of items that are within SLA for a team. This is live data so when the dataset changes, so does the table. I want to be able to copy and past...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 19, 2020

Iank95 

Didn't understand screenshot, but perhaps

=if(today()>=C7,C3,"")

could work.

  • Iank95's avatar
    Iank95
    Copper Contributor
    Nov 19, 2020

    SergeiBaklan 

    Hi Sergei, 

     

    Sorry, the screenshot was out of context. The first table in the screenshot tells me how many are inside/ outside of SLA today. This Table pulls from a live data set. 

     

    I want to create a second table where I get a snapshot of this data every Friday but it is a static view. i.e. the following week once the data has changed it will not affect the data from the previous week.

     

    The formulas both you and I mentioned work for a live view but they are not static, they will change as the data changes. 

     

    What I am looking for is essentially a "paste values" whenever the if statement criteria is true. In this case, it is a certain date. 

     

    Do you think this is something you could help me with?

     

    updated screenshot attached

     

    Thanks

    Ian

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 19, 2020

      Iank95 

      Thank you, it's more clear now. Perhaps it could be done something with formulas if enable iterative calculations and use circular references, similar to timestamp pattern. But that's not reliable way, option could affect other calculations in this and other workbook.

       

      More logical to play wit VBA programming, but that's not my territory.

Resources