Adding parent row data to child row

OK I have a dataset of payments info that shows payments made against invoiced services. The payment info is on one row (amount, date, check#), followed by the multiple line items describing each service the payment is paying for (subamount, PO#, invoice#, service description). Each item in parentheses separated by commas represents a column.Then the second payment info follows on a row, followed by the line item this second payment is paying for. Etc. So effectively the payment info is grouped together with its line items on opening of the spreadsheet. There is no pattern to how many line items exist under each payment. Could be one or many. However if you were to randomize the sorting of the rows, there would be no way to tell what line item belongs to what payment. So I was looking to automate adding payment info data to each line item. Is there a way to do this?

So it looks something like:

row1: payment1 info (amount, date, check#)
row2: payment1 line item 1 (subamount, PO#, invoice#, service description)
row3: payment1 line item 2 (subamount, PO#, invoice#, service description)
row 4: payment1 line item 3 (subamount, PO#, invoice#, service description)
....repeat...
row n+1: payment2 date (amount, date, check#)
row n+2: payment2 line item 1 (subamount, PO#, invoice#, service description)
row n+3: payment2 line item 2 (subamount, PO#, invoice#, service description)
row n+4: payment2 line item 3 (subamount, PO#, invoice#, service description)
...etc...

One minor point is that the payment info data is in separate columns from the line item info, except for the amount & subamounts which appear in the same column.

What I would like to do is find a formula or macro to add at least the date and check# to each corresponding line item row.

Would this have to be a macro?

Code here from post #4

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
[B][I]


See attached: results in "BEFORE"