Okay, Bob, that worked. If this is a one-time occurrence, manual exercise is fine. If this is going to be a recurring event, I would probably use VBA recordset or PowerQuery.
I don't know if there is a formula to accomplish this.
Okay, Bob, that worked. If this is a one-time occurrence, manual exercise is fine. If this is going to be a recurring event, I would probably use VBA recordset or PowerQuery.
I don't know if there is a formula to accomplish this.
Last edited by June7; 03-06-2023 at 07:39 PM.
How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote