• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy range from another sheet and paste into "active sheet"


Well-Known Member
To confirm, do you have the FILTER function available to you as a function in a worksheet formula?


New Member
no problem. I appreciate your help.

With regard to the filter Function, yes I have it, just not the filter formula which is available on 365.


Well-Known Member
The attached has a hidden sheet called ControlLists. The ranges named in these lists are what will be used in the userform, so you can name the named ranges as you like - no special prefix is used.
You can bring up the userform with Ctrl+i on the keyboard.