This work but i also want to copy the 1st row of excel1 till column Service_Period until it reach empty row.

The image displays a spreadsheet with a list of invoices, detailing information such as the supplier, invoice number, due date, purchase and sales order, organization name, payable amount, totals, description, quantity, rate, amount, and term start and end dates. (Captioned by AI)1711×112 7.71 KB