Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter two worksheets w/ the first as a controller
morning all.
I'm doing some data verification and have set up two worksheets with filters on both of them. So that I can avoid going back and forth to keep adjusting my filter for each sheet, is there a way that I can "link" the two filters to be as a single filter for both sheets? I.e., I'd like to just set the filter on one sheet to adjust the filter on the other worksheet as well. As I spoke with a colleague to see if he'd tried this before, I realized that I may have not stated my request correctly/succinctly enough. I've filtered two worksheets. The primary sheet is a more comprehensive/detailed listing. The second worksheet is a "summary" of all the data on the first sheet. I want the first worksheet to be the controller. So if I set the filter to a specific critieria on sheet A, it automatically sets it to the identical criteria on sheet B. How would I perform that? Again, thank you for your helps. Oh, I did try Ron DeBruin's Easy Filter xla, it doesn't work for XL2007. It called up a little message box saying it only works for XL 2000 thru 2003. I've then reviewed Contexture's website on filtering worksheets, and they do not appear to discuss my goal. Thank you. Best. SteveB. I'm using XL2007. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter two worksheets w/ the first as a controller
Ok, as a follow up, I did find, and try Advanced filtering.
It does not work for my desired purpose. I tried selecting the range of interest on my detail sheet, and then the criteria range on my summary sheet. It only allowed one item. No matter what I selected on my summary sheet it did not change the filtered values of my detail sheet. I then reversed my process to set the range of interest on my summary sheet, and criteria range on my detail sheet. Same-- nothing changed. So, my next question then goes to: Can filtering two worksheets linked together with one sheet being the controller work? Thank you. SteveB. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter two worksheets w/ the first as a controller
On Sep 29, 8:43*pm, SteveDB1
wrote: Ok, as a follow up, I did find, and try Advanced filtering. It does not work for my desired purpose. I tried selecting the range of interest on my detail sheet, and then the criteria range on my summary sheet. It only allowed one item. No matter what I selected on my summary sheet it did not change the filtered values of my detail sheet. I then reversed my process to set the range of interest on my summary sheet, and criteria range on my detail sheet. Same-- nothing changed. So, my next question then goes to: Can filtering two worksheets linked together with one sheet being the controller work? Thank you. SteveB. I have the same issue and would appreciate any help at all on using the filters on one sheet to control the same filters on other sheets. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter two worksheets w/ the first as a controller
Hi Jason.
Here is what I'm using to filter two different worksheets. I use it daily, and am very pleased with it. I even have one template worksheet with this macro linked to it for the work that I do. ----------------------------- Sub Filtration() mv = Range("f3").End(xlDown).Value ' this sets the criteria. 'MsgBox mv- for verification. Sheets("Sum").Range("A8:F8").AutoFilter field:=1, Criteria1:=mv '"12345" mv1 = Range("a3").End(xlDown).Value 'this is my add-on to set a second criteria filter- Name of owner. Sheets("SheetName").Range("A8:F8").AutoFilter field:=3, Criteria1:=mv1 'this takes in to account the owner name for a filter. End Sub ----------------------------- Let me know if you need any explanations. I obtained this from Don Guillett. Hope this helps. Best. SteveB " wrote: On Sep 29, 8:43 pm, SteveDB1 wrote: Ok, as a follow up, I did find, and try Advanced filtering. It does not work for my desired purpose. I tried selecting the range of interest on my detail sheet, and then the criteria range on my summary sheet. It only allowed one item. No matter what I selected on my summary sheet it did not change the filtered values of my detail sheet. I then reversed my process to set the range of interest on my summary sheet, and criteria range on my detail sheet. Same-- nothing changed. So, my next question then goes to: Can filtering two worksheets linked together with one sheet being the controller work? Thank you. SteveB. I have the same issue and would appreciate any help at all on using the filters on one sheet to control the same filters on other sheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use "Filter" to filter one range in many worksheets at a time | Excel Worksheet Functions | |||
Filter all worksheets in workbook | Excel Programming | |||
Worksheet controller | Excel Worksheet Functions | |||
Petty Cash Controller | Excel Discussion (Misc queries) | |||
Parts Stock controller... | Excel Worksheet Functions |