Pasting Copied Cells into Column Right After Last Column with Data

[boldcode]

Hello,

I want to create a macro that copies cells starting with “ N3 ” to the very last cell with data within Column N and then pastes the copied cells in the column right after the last column that contains data starting in row 3. In addition, getting rid of the marching ants would be great as well.

As part of this post I am providing you with a workbook that visually shows you what I am looking for. In the first worksheet of this workbook named “Before Macro Execute” just simply shows you what the data looks like before it will be manipulated by the macro. The second worksheet is named “After Macro Execute” and it shows obviously the results that I’m looking for. I highlighted cells in column N just to make it easier to spot in both worksheets. Also, in the worksheet "Before Macro Execute" the last column with data is "Q", but this might not be the case every time it could easily be column "S".

Thanks

[AB33]

Try the attached.

[boldcode]

AB33,

Works great, thank you for your time!

- BC