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

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

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

Why can't you insert a new column? Are you already using 256 columns (or 16384
columns)?



driller wrote:

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


--

Dave Peterson

Sir Dave,

I do now the drills to check if all column does have data, i am now confused
how to check- if this particular sheet needs a helper sheet or *macro* to
verify if there is a free column somewhere ....
what I observed is that this sheet has many transposed formulas....so i also
have to list down at which row() range they reside...in order to insert a
column somewhere between *A-IV*...the transposed resident formulas do not
have an alias_name defined...really hard but still trying hard to make it
easy, timewise..

thanks for your time and effort,

--
regards,
driller

*****
- dive with Jonathan Seagull



"Dave Peterson" wrote:

Why can't you insert a new column? Are you already using 256 columns (or 16384
columns)?



driller wrote:

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


--

Dave Peterson

You could use a formula like:

=counta(a2:a65536)
to see if column A has any data/formulas in row 2 to row 65536.



driller wrote:

Sir Dave,

I do now the drills to check if all column does have data, i am now confused
how to check- if this particular sheet needs a helper sheet or *macro* to
verify if there is a free column somewhere ....
what I observed is that this sheet has many transposed formulas....so i also
have to list down at which row() range they reside...in order to insert a
column somewhere between *A-IV*...the transposed resident formulas do not
have an alias_name defined...really hard but still trying hard to make it
easy, timewise..

thanks for your time and effort,

--
regards,
driller

*****
- dive with Jonathan Seagull

"Dave Peterson" wrote:

Why can't you insert a new column? Are you already using 256 columns (or 16384
columns)?



driller wrote:

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


--

Dave Peterson


--

Dave Peterson