In the attachment shown in the link below, I have created a sample of data that I need to program as follows for rows 11 to 24.

I copied the first row 11 down to a blank area (shown here in rows 26 to 33 with blank rows for illustration only). I need the macro to paste that row 11 8 times as shown in my sample file. Then I go to column I and paste values from range name split. Next I move over to Column Q, then to R,S,& T. In each of those four columns, I multiply the negative value of the corresponding cells in row 11 times the decimal in column I that was pasted into that row.The first cell is $Q$11*I26 so that it can be copied down through row 33. Column R is handled with the same formula multiplying first by cell I26 etc.

Then the loop starts over, copying row 12 in this example and pasting it 8 times and then going through the same routine shown above until all negative rows have been reallocated as positive values.

This sample data is a test of one month. Essentially for a regulatory report, we are backing out old values in the first twelve rows, and then splitting it out for 8 different leases when a constant proration for each lease as shown in the range "split".

I could do 12 rows like this without using a macro, but the actual report will have 450 backout lines in succession that need to be broken out to 3,600 lines that have positive values. The positive lines in total of course will offset the negative lines and have a zero balance for each column when I am done.

Here is my link to my onedrive file. I have not ever shared a onedrive file on here before. Please let me know if you have problems getting the spreadsheet and editing it as needed.




https://onedrive.live.com/redir?resi...nt=file%2cxlsx