Complicated If Function Question

  • Thread starter Thread starter Mark B.
  • Start date Start date
M

Mark B.

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.
 
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?
 
Hi,

Thanks for your response.

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

Mark
 
Back
Top