Put your formula into row 2 of a helper column (headers in row 1)
Drag it down as far as you need
apply data|filter|autofilter to that column (or range)
show the rows you want to copy

Select that visible range
edit|copy

Off to the other sheet's destination cell.
Edit|paste

driller wrote:

hello,

Please give some guidance if it is possible and how i can filter-rows to
select only e.g. equals =MOD(ROW(),100)=0, something like that....

I just wanna get easy yet the-precise location where I will paste my data.
without bothering the hidden rows()..

thanks in advance..
--
regards,
driller

*****
- dive with Jonathan Seagull

--

Dave Peterson