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