Copy column and paste info in every nth cell

I want to create a macro that is run after a user copies information from a column. The user would move to another tab, select a cell, and run the macro. The macro would insert the copied information in every 10th cell. Any ideas on the best way to do this?

Copy
1
2
3
4
5


Paste
1


2


3


4


5

Originally Posted by johnsjg

I want to create a macro that is run after a user copies information from a column. The macro would insert the copied information in every 10th cell.

Clarification
"paste in every 10th cell" ....as in every 10th row of a certain column?

How large of a range is the original information in?

Yes every 10th row of a certain column. Typically 5-7 cells in the original table. It varies.

I'm sure there is a better way to do this and maybe someone will chime in and show us so we can learn, but for now.......
......here is what I came up with.


It adds 10 rows and works for 7 rows pasted data, you can add to the code if more rows are needed.

Run macro "AddTenRows"