If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Filter and Autopopulate
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 |
#2
|
|||
|
|||
Excel Filter and Autopopulate
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 |
#3
|
|||
|
|||
Excel Filter and Autopopulate
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 |
#4
|
|||
|
|||
Excel Filter and Autopopulate
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 |
Thread Tools | |
Display Modes | |
|
|