I believe I have solved a problem like the one you are describing. Do you mean that selecting on one field will cause selection in another field in a table that is not linked, by using a macro? Can you describe your goal in more detail?
I will, when I select Filter in "BP Accounnt Group Billing " for Example "Corporate" in Entwicklung Sheet, automatically the same Filter in "BP Accounnt Group_Order" in Order Analyse. Or the same Filter for Hierarchy1 or Hierarchy 2 .......or all.
at the moment the Order sheet work just with the Filter Order, I will Remove the Order sheet and concet the Billing with Order together in One Sheet. This work when the same Filter in Billing Shett Field is same Field in Order sheet.
The Order sheet work at the moment just with the filter in Order and in the Entwicklung work at the moment just with the filter in Billing.
I will have one worksheet for the billing and Order and just filter Billing and automatickly set the same filter in Ordertabel.
No of Order doesn't work with the filter in Entwicklung.
I hope you understand me. sorry for my bad Englisch.
