L
Len
Hi,
I'm not sure how to modify an excel macro to stop copying down values
from adjacent column when no data found in auto-filtering.
Say, an excel macro is set to copy down data range from A3 to K50 ( ie
the last used cell ) where the auto-filtering set on header J2 to
filter out value > 0 in J column.
Excel Macro will copy down values from A3 to K column last used cell
for both data found ( is value > 0 ) and no data found ( ie blank
cell ) in filtering column J
How to set excel macro to stop coping down values from A3 to K column
of last used cells, for no data found in column J after filtering the
value > 0
Thanks & Regards
Len
I'm not sure how to modify an excel macro to stop copying down values
from adjacent column when no data found in auto-filtering.
Say, an excel macro is set to copy down data range from A3 to K50 ( ie
the last used cell ) where the auto-filtering set on header J2 to
filter out value > 0 in J column.
Excel Macro will copy down values from A3 to K column last used cell
for both data found ( is value > 0 ) and no data found ( ie blank
cell ) in filtering column J
How to set excel macro to stop coping down values from A3 to K column
of last used cells, for no data found in column J after filtering the
value > 0
Thanks & Regards
Len