again
 

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

again
 

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

again
 

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

again
 

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

again
 

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

again
 

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

again
 

thanks,
the formula counta works in reality...
yet i am sorry that i forgot to inform there are rows which have full
colors,containing cells where conditional formats resides <maybe for data
entry or validation purpose ...really i cant even paste anything in these
cells along with any one column...

thanks for your time and effort..


--
regards,
driller

*****
- dive with Jonathan Seagull



"Dave Peterson" wrote:

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

again
 

I'm out of suggestions. I don't know a way to use data|filter|autofilter if you
can't filter by a column in the worksheet.

driller wrote:

thanks,
the formula counta works in reality...
yet i am sorry that i forgot to inform there are rows which have full
colors,containing cells where conditional formats resides <maybe for data
entry or validation purpose ...really i cant even paste anything in these
cells along with any one column...

thanks for your time and effort..

--
regards,
driller

*****
- dive with Jonathan Seagull

"Dave Peterson" wrote:

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


--

Dave Peterson

again
 

thanks Sir,

I'll just try to refresh the post and probably other freshcomers can suggest
also...

sincerely
--
regards,
driller

*****
- dive with Jonathan Seagull



"Dave Peterson" wrote:

I'm out of suggestions. I don't know a way to use data|filter|autofilter if you
can't filter by a column in the worksheet.

driller wrote:

thanks,
the formula counta works in reality...
yet i am sorry that i forgot to inform there are rows which have full
colors,containing cells where conditional formats resides <maybe for data
entry or validation purpose ...really i cant even paste anything in these
cells along with any one column...

thanks for your time and effort..

--
regards,
driller

*****
- dive with Jonathan Seagull

"Dave Peterson" wrote:

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


--

Dave Peterson