Hi!

I recently posted the below question and received a correct answer to it.
Unfortunately for me, the correct answer involved using a macro, and I cannot
use this macro in my process. I am looking to resolve the below question in
excel without using a macro, the only thing I can think of is an if(vlookup)?
Any other suggestions?


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

You can use Data-Advanced Filter on the destination sheet referring to the
data range by NAME

See http://www.contextures.com/PhoneList.zip at Debra Dalgleish's site...
Disable macros and use Advanced Filter after specifying the range as
'Database'

"Philip" wrote:

Hi!

I recently posted the below question and received a correct answer to it.
Unfortunately for me, the correct answer involved using a macro, and I cannot
use this macro in my process. I am looking to resolve the below question in
excel without using a macro, the only thing I can think of is an if(vlookup)?
Any other suggestions?


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

Hi,

Thank you for the reply. I found out a way to do the advanced filter,
however is there a way to make this autopopulate or calculate on it own
without a macro being used?

Thank you,

Philip

"Sheeloo" wrote:

You can use Data-Advanced Filter on the destination sheet referring to the
data range by NAME

See http://www.contextures.com/PhoneList.zip at Debra Dalgleish's site...
Disable macros and use Advanced Filter after specifying the range as
'Database'

"Philip" wrote:

Hi!

I recently posted the below question and received a correct answer to it.
Unfortunately for me, the correct answer involved using a macro, and I cannot
use this macro in my process. I am looking to resolve the below question in
excel without using a macro, the only thing I can think of is an if(vlookup)?
Any other suggestions?


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

You need to somehow tell Excel that you want the filter to run again... You
can do that either through Menus or a macro...



"Philip" wrote:

Hi,

Thank you for the reply. I found out a way to do the advanced filter,
however is there a way to make this autopopulate or calculate on it own
without a macro being used?

Thank you,

Philip

"Sheeloo" wrote:

You can use Data-Advanced Filter on the destination sheet referring to the
data range by NAME

See http://www.contextures.com/PhoneList.zip at Debra Dalgleish's site...
Disable macros and use Advanced Filter after specifying the range as
'Database'

"Philip" wrote:

Hi!

I recently posted the below question and received a correct answer to it.
Unfortunately for me, the correct answer involved using a macro, and I cannot
use this macro in my process. I am looking to resolve the below question in
excel without using a macro, the only thing I can think of is an if(vlookup)?
Any other suggestions?


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