copy row content from one worksheet to another, if a condition met

[Lorilenore]

Hi,
I need to be able to copy content from one worksheet (contests) to another
worksheet (current) if Status = Open.
On Contests column A is Status.
If Column A1 = Open, I want to copy content from B1:I1 to worksheet Current
starting in spot A1 and continue to end of list.

Basically I have a bunch of contests I am tracking on worsheet Contests. I
only want contest that are "Open" to appear on my current sheet.

I have to update this information weekly so I am wondering what is the
easiest way to get things done and will have a minimal amt of upkeep

 

[ND Pard]

Consider setting a filter where Status = Open.

Then simply copy and paste (if necessary) to your new workbook.

 

[Max]

One simple play which drives it out automatically ..

Assume source table in sheet: contests,
in cols A to I, data in row 2 down
key col = col A (status)

In sheet: current,
In A2: =IF(contests!A2="Open",ROW(),"")
Leave A1 blank. This is the criteria col.

In B2:
=IF(ROWS($1:1)>COUNT($A:$A),"",INDEX(contests!A:A,SMALL($A:$A,ROWS($1:1))))
Copy B2 across to J2. Select A2:J2, copy down to cover the max expected
extent of data in contests' col A, say down to J500? Minmize/hide col A. Cols
B to E will return the exact results that you seek, with all lines neatly
bunched at the top.