Hi, can someone please help me with a macro. In column AP I have a series of numbers and blank rows. I am looking for a macro that will loop through column AP starting in cell AP2. The macro would skip blank rows and cut and paste the numbers it found into column AQ but would also offset down by the number that was just cut and pasted from column AP to AQ. For example, if I had the number 2 in cell AP2 and the number 5 in cell AP6 then the macro would cut and paste AP2 to AQ4 and AP6 to AQ11 then return back to column AP and cut and paste the next number found. The numbers values and position in column AP are not always the same. Thank you in advance for your help.