Yeah, while I myself can deal with Power Automate / Powershell, the average company layman user still can't even do an index match formula, so there's no way th

Yeah, while I myself can deal with Power Automate / Powershell, the average company layman user still can't even do an index match formula, so there's no way they are going to understand anything that complex. I've done what you have done and demonstrated the pasting into grid view. But this requires a perfect placement of the cursor and also the slow as f*ck row-by-row validation+commit to the database is outright comedic.