Hello,

I have columns of information like the one below on one worksheet. Based on
certain criteria, I want to copy and paste these columns to another
worksheet in the same file. The "4" above John Smith's name would be the
criteria. The criteria can range from 1 to 5 in a given cell. After you
glance at the info below, please scroll down for a little more info.

Column A

Row 1 4
Row 2 John Smith

Row 3 1

Row 4 1
Row 5 1

Right now, these columns show up on every other column in the original
worksheet and I want to paste them to every other column in the destination
worksheet depending on the value in row 1. The rows that I want to copy and
paste are from A2 - A227. If necessary, I can change the spreadsheets so the
columns are next to each other.

Can anyone help me?

Thanks in advance.