Forum Discussion
Urgent 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 in progress for a team. This is live data so when the dataset changes, so does the table. I want to be able to copy ...
It seems you answered your own question. "Paste Values" is the only answer, unless you want a macro to auto paste the results for you.
Since your formula is taking the TODAY function, when the date doesn't equal any of the provided dates in row 3, the result will be blank.
Hi thanks for your response.
This doesn't do what I need because it will always be referencing that cell. So as the date changes it will appear blank. Once the date criteria is fulfilled I want it to paste the value so that it is then static and will not change so I can see the trends on a week on week basis. Do you know how I can do this? Is there a paste values formula? I can't seem to find one.
Thanks
Ian
