Hi all,
I'm not sure if this is the right place to ask, but I'm looking for a typescript solution where Sheet1 contains rows (A:K) of information - at the end of each row (K) is a "yes" or "no" data validation drop down - if the value is "yes", copy the entire row onto the next blank row of Sheet2. If it is "no", do nothing.
I've used formula in the past to do similar tasks (with drawbacks... its a lot of data which results in a lot of formulas), as well as using VBA, with which I am far more familiar. Unfortunately, I can no longer rely on VBA for reasons, so I will require a script for Excel online... and then probably use power automate?
I'm not sure if this is the right place to ask, but I'm looking for a typescript solution where Sheet1 contains rows (A:K) of information - at the end of each row (K) is a "yes" or "no" data validation drop down - if the value is "yes", copy the entire row onto the next blank row of Sheet2. If it is "no", do nothing.
I've used formula in the past to do similar tasks (with drawbacks... its a lot of data which results in a lot of formulas), as well as using VBA, with which I am far more familiar. Unfortunately, I can no longer rely on VBA for reasons, so I will require a script for Excel online... and then probably use power automate?