thanks Sir Dave,
that's a nice exercise,, problem is i cannot copy the formulas through-out
any one column, so, i hope i have no data/formula existing somewhere there
<in the *supposed* hidden rows...

Is there any other thing i can do about it?
with kind appreciation...thanks again.
--
regards,
driller

*****
- dive with Jonathan Seagull



"Dave Peterson" wrote:

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