data
 

Hi
I have a list of Numbers in a column For example Col A1 has the following
data .101,101,101,101,102,102,102,103,103,104,105,106,1 06,..... and so on ..
To this column i have set the filter.. Now my data in the filter give the
following values 101,102,103,104,105,106...so on...
Now i want to copy the list of data in filter to another column~
Can someone guide me...

data
 

Select the filtered rows Copy
Then in another sheet, just right click on say A1 paste
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Srinivas" wrote:
Hi
I have a list of Numbers in a column For example Col A1 has the following
data .101,101,101,101,102,102,102,103,103,104,105,106,1 06,..... and so on ..
To this column i have set the filter.. Now my data in the filter give the
following values 101,102,103,104,105,106...so on...
Now i want to copy the list of data in filter to another column~
Can someone guide me...

data
 

Hi Max,
Thanks for the reply .But i want to copy only the values displayed in the
filtered box at one go and not the data which falls below the filtered
Numbers.

Regards


"Max" wrote:

Select the filtered rows Copy
Then in another sheet, just right click on say A1 paste
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Srinivas" wrote:
Hi
I have a list of Numbers in a column For example Col A1 has the following
data .101,101,101,101,102,102,102,103,103,104,105,106,1 06,..... and so on ..
To this column i have set the filter.. Now my data in the filter give the
following values 101,102,103,104,105,106...so on...
Now i want to copy the list of data in filter to another column~
Can someone guide me...

data
 

Yes, but the step was given earlier to select the *filtered rows* only
Select the filtered rows Copy

(Select only the blue row headers)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Srinivas" wrote:
Hi Max,
Thanks for the reply .But i want to copy only the values displayed in the
filtered box at one go and not the data which falls below the filtered
Numbers.