Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 82
  • Last Modified:

Filters for Calculator

I would like assistance with creating several filters that act as a drill down.  In the workbook that I am attaching all of the data resides on the PrSchTab. I would like to take the data from the PrSchTab and be able to use to filter for information in the Production Source area on the Schedule Calc tab.

Starting with column labeled Brand, once the brand is selected would only like to see the Type that is associated with the brand this can include blanks.     Once the Type is selected would then only like to see the Partner (field can be blank) then from there the Factory and Location can be selected, however these are dependent on the category which is hard coded into the Production Source calculator Lines D16:D2.

The end result is to get the Production Lead TIme number so that a date can be calculated and populated in column G on Schedule Calc Tab

I have comments on the attached workbook.

Please let me know if there are additional questions.
EE-Help-2015.01.16.xlsx
0
jmac001
Asked:
jmac001
  • 9
  • 7
1 Solution
 
Martin LissOlder than dirtCommented:
Try this.
Q-28598152.xlsm
0
 
jmac001Author Commented:
Hi Martin getting a run time error 32809 when debugging it is at Function TheFilterRow. Highlighted in yellow For each rcell...
0
 
Martin LissOlder than dirtCommented:
It doesn't happen to me so please describe the exact steps that led to that error. What version of Excel do you use?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
jmac001Author Commented:
I am using 2010.  When I select all of the criteria (all cells in orange) and then click the update button.   Also received an error when I tried to reset (same error number as above)
0
 
Martin LissOlder than dirtCommented:
After selecting the criteria in each of the orange cells that you want to filter, just press one of the two yellow buttons. No need to select the orange cell's first.
0
 
Martin LissOlder than dirtCommented:
Here's a quicktime movie of me doing it in Excel 2010. Change the extension from jpg to mov.
Screen-Recorded2015-01-16-13-39-05-.jpg
0
 
jmac001Author Commented:
Ok now that I see what is suppose to happen the data is not drilling down at all when I select the first filter all of the data is still in the table (BA & WI).  

Is there anyway to take the information and have the drill down information populate on the first tab?
0
 
Martin LissOlder than dirtCommented:
I don't know what's going on at your end but it works for me. Here's a picture and you can also see it happening in the movie I posted.
Works for me
0
 
jmac001Author Commented:
I am working to see if I can identify why the code is not working
0
 
Martin LissOlder than dirtCommented:
Did you happen to save the file in some format that doesn't save the code (like xlsx)? You can tell by going to Visual Basic and seeing if there's any code there. You could also download a fresh copy of my attachment and see if it works. If you still have a problem after that please describe, step by step, what you are doing.
0
 
jmac001Author Commented:
Still having problems I've downloaded the files a couple of times and tried to filter.  The file is .xlsm when opening I get the enable editing which I say yes to.  Double checked and there is code on the modFloatCombo module and Sheet2(PrSchTab).  At a lost as to why the code is not working.
0
 
Martin LissOlder than dirtCommented:
I downloaded the file I posted in post ID 40553830, clicked on cell A35, pressed the little dropdown arrow, chose "BA" and got just what the picture in post ID 40557835 shows, so if that's what you are doing and it doesn't work for you, I'm stumped.

We might be able to find out what's going on if we debug it together but if you want to do that I'd like to schedule an hour with you when we're both available so we can do it "live".
0
 
jmac001Author Commented:
Hi Martin,  

The issue that I am having is related to being on network.  When I downloaded and opened off of network I was able to get the filters to work as demonstrated in your video.  Is this something that you would be able to troubleshoot?   Do I need to consider or is there a different way to get the information that I am looking for?

I noticed In the current code you can only update the schedule for 1 item on the first tab.  The end goal is for the user to have a date populated for each one of the categories (Tile, Perimeter, Floor, Store Front, etc).
0
 
Martin LissOlder than dirtCommented:
Unfortunately I have zero expertise when it comes to running Excel on a network so I think you'll need to ask for someone else's help. I'm not upset and I'm happy to know what the problem was, but in future questions you should make sure to mention that you want to run from the network if that's the case.
0
 
jmac001Author Commented:
Thanks for your patients while I troubleshoot the issue, this is the first time that VBA has not worked on the network.
0
 
Martin LissOlder than dirtCommented:
You're welcome and when you find out why, please keep me informed.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 9
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now