Personally I wouldn't use a looping macro, certainly not as a first choice when there are often more elegant and better ways. IMO loops are always a brutal last ditch resort when all else fails.
In your case the formula
put into a spare column on row 6 and copied down will produce the results you want. Then it's a simple matter to copy the column and paste it as values to G6.
You would also speed up your macro if you avoid .Select and .Activate. These always slow the macro down. Just refer directly to the object in question. For instance your instruction
is redundant. The line
is sufficient if the macro is run when the P_L sheet is the active sheet and if its not just qualify the range by adding the sheet name.
Bookmarks