Overwriting existing data in a primary sheet with updates from "helper" sheet
Looking for some ideas on how to overwrite data with updated information between a primary sheet and a helper sheet.
Primary Sheet "PO Entry" is used for recording purchase orders, and delivery dates. There CAN be a partial delivery on a PO, and that impacts the admin fee that gets paid.
In cases where there's a partial delivery, I have a workflow set up to copy the row to my "helper" sheet, which has three extra columns to calculate the new PO balance (what's the total sale value of the remaining items for delivery), remaining balance helper (shows the remaining admin fee due for internal verification), and remaining item helper (shows number of items remaining for delivery).
Where I am incredibly, horribly stuck, is overwriting the PO data in my primary sheet to show the updated balances. PO issue date, number, bid item, and estimated delivery would stay the same; "quantity ordered" value would change to the "remaining item helper" qty, "item amount" would change to "new PO balance" value.
Any thoughts? Is this even possible?