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/mo...-series.42419/
Nabeel
Reply With Quote