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

Move Filtered Data & series


Hi Gurus

I have attached sheet with sample, I want filtered data to move/copy next sheet with additional columns!
In these columns I want numbers in break and with min break as I made sample, in count columns there is only count of numbers after every blank cell,
in column B min series will be 2 numbers & there will always blank cell after series break, series in min break in column D will like <10.
Sheet1 doesn’t exist I added for make sample, If I changed filter in NMS(I used short name here) sheet then data will copy according, sheet1 will create one time if i change filter in first sheet and run code than only filtered data will move/copy!
Thanks in advance



Last edited: