My range is e12:e734 (e734 will change every time, but column will not change). Find nonblank cell for example E14 then formula in h14=1-(G14/(F14*E14)). Then I have to filter non blank cell A12:H734, copy visible sheet and copy it in new sheet. I got stuck to find nonblank cell and next nonblank cell. I will be greatfull for your help.