How about just using
datafilterautofilterfilter on "billable"copy/paste. Record a macro if
often.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Philip" wrote in message
...
Hey!

I have a drop down menu with certain values (in my case, one of the drop
downs is titled "Billable"). I am trying to figure out how I can create a
formula which searches for all items labeled "Billable" and then pulls a
range of data associated with that label and populates only that data into
a
new worksheet.

Do you have any advice on how I can do this?

Thank you so much for your help,

Philip