| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) | |||
Linear Mode
