• 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

    Hui...

  • 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"

p45cal

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

Lazarous

New Member
Pascal,
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.
 

p45cal

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.
 

Attachments

Top