Hey mdnghtsnpr,

Thanks for the quick response. I think I may be missing something from your response. The data is already sorted to the extent necessary. I'm looking for a macro / formula that can paste whatever non-blank entry in the "$PSFAdj" column down a certain number rows. The number of rows to be pasted down is determined by the "Count" column. Only catch is the number in the "Count" column will change occasionally. In my example above I used 8 rows but sometimes its 2 and sometimes its 140, all within the same data set, based on the number of related entries. I hope this helps clarify the question. Let me know if the sorting you've proposed above can do this and if I'm missing something from the code. Thanks again for the response. Have a great one.