VBA: list rows only if column L is filled

July 26, 2011 at 10:20:40
Specs: Windows 7
Hi! VBA moron and excel intermediate here, thanks in advance for any help!

I have an excel 2010 sheet containing rows of employee information. Here is a sample (hope it works, ignore formulas please):

HTML Code Deleted By Moderator

I need to duplicate this list on another sheet of this workbook, but including only active employees. I am looking for a macro that would populate only rows where column L contains a value (X, in this case).

Please let me know if you need more information!

See More: VBA: list rows only if column L is filled

July 26, 2011 at 10:25:57
Oops, guess that didn't work, eh? Here is my second attempt :)

# Name Job ID Start Location Mgr Thruput Billable Burden Active End
1 Amy Analyst 2009 N Smith TRUE $- $- 2011
2 Ben Analyst 2009 S Smith FALSE $- $- X
3 Cindy Analyst 2009 W Smith TRUE $- $- X

Report •

July 26, 2011 at 14:47:58
Please click on the following line and read the instructions on how to post data so that it lines up proberly in this forum. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question