Compting 99% of a col range while autofilter is on.

A

Aligahk06

Dear All,

I am in filter mode while copying and pasting in filter mode generated error
cannot paste.
In filter mode i have column which consists of numerical value.
Being in Auto filter mode i want some column range Let it Be start from G11
and upto G...
I want to change the value of numerical value Col G as 99%.( Auto filter is
on)

Is there any way or macro to do this ?

Please assist ?

Rgds,
Aligahk06
 
D

Dave Peterson

If you're changing the values of the visible cells to 99%, you can

select the range
Edit|Goto|special|visible cells only
type: 99%
hit ctrl-enter to fill all those visible cells with that value.

If you're pasting, then your range to paste has to be contiguous--maybe you can
sort first, then paste, then resort your data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top