PDA

View Full Version : Move Filtered Data & Get series of Numbers



Gondal
08-27-2019, 12:39 AM
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!

logic of column B is A3-A2=1 and logic of column D is A3-A2<10
Thanks in advance

was also posted here!
https://chandoo.org/forum/threads/move-filtered-data-series.42419/

Nabeel