I need help making a macro to grab info from cells A1:A5 and B1:B5 and paste values from A1 to A20 and B1 to A25 then write/append range A17:A28 to a text file, then repeated for each until blank found in column A


Row --------------- ------ column A -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - B
A1 ---- "options": "value {hostname=\"FC-AP-LOUNGE\", metric=\"rta\", service=\"ping4\"}" ----- B1 ---- "value": "FC-AP-LOUNGE"
A2 ---- "options": "value {hostname=\"FC-AP-707-715\", metric=\"rta\", service=\"ping4\"}" -----B2 ---- "value": "FC-AP-707-715"
A3 ---- "options": "value {hostname=\"FC-AP-UNIT-920\", metric=\"rta\", service=\"ping4\"}" ---- B3 ----- "value": "FC-AP-UNIT-920"
A4 ---- "options": "value {hostname=\"FC-AP-UNIT-406\", metric=\"rta\", service=\"ping4\"}" ---- B4 ----- "value": "FC-AP-UNIT-406"
A5 ---- "options": "value {hostname=\"FC-AP-UNIT-320\", metric=\"rta\", service=\"ping4\"}" -----B5 ----- "value": "FC-AP-UNIT-320"




A17 {
A18 "matcher": {
A19 "id": "byName",
A20 paste from A1
A21 },
A22 "properties": [
A23 {
A24 "id": "displayName",
A25 Paste from B1
A26 }
A27 ]
A28 },