Hello,

I have columns of information like the one below on one worksheet. Based on
certain criteria, I want to copy these columns to another worksheet in the
same file. The "4" above John Smith's name would be the criteria. 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. The rows are from B1 - B227. If necessary, I can change the
spreadsheets so the columns are next to each other.

Can anyone help me?

Thanks in advance.

Hi,

Thanks for your response.

Yes. If a 4 is in A1, copy everything from A1:A227 to the new worksheet.

Mark
"Luke M" wrote in message
...
Please clairify:
If a 4 is found in A2, does that mean to copy all of a1:A227 to the new
sheet, or just row 2? Or only if a 4 is found in everay column of that
row?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mark B." wrote:

Hello,

I have columns of information like the one below on one worksheet. Based
on
certain criteria, I want to copy these columns to another worksheet in
the
same file. The "4" above John Smith's name would be the criteria. 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. The rows are from B1 - B227. If necessary, I can change the
spreadsheets so the columns are next to each other.

Can anyone help me?

Thanks in advance.