Copy and paste looks simple, but the clipboard, selected row, and destination field must all advance correctly between cycles.
Map the whole cycle
Record the selection, copy shortcut, app switch, destination focus, paste, and return path as one complete cycle.
Keep source and destination aligned
MacroLoop can reproduce the cross-app path. Use a small prepared batch, keep sorting fixed, and add a visible marker only after the destination value is confirmed.
MacroLoop is especially useful when copy and paste crosses two visible Mac apps.
Watch for stale clipboard data
A stale clipboard can paste the previous item into multiple records. Stop when selection does not visibly change or when the destination rejects a value.
THE TAKEAWAY
Treat source selection and destination focus as part of the copy-and-paste automation.