data

G

Guest

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,106,..... 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...
 
G

Guest

Select the filtered rows > Copy
Then in another sheet, just right click on say A1 > paste
 
G

Guest

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
 
G

Guest

Yes, but the step was given earlier to select the *filtered rows* only
(Select only the blue row headers)

---
 

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

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Creating A List of Items Between Two Numbers 2
SUBTOTAL not refreshing when using advanced filter 2
Filtered drop down list 2
A macro to hide rows 5
COUNTIF Function on filtered data 2
Removing blank spaces from the ends of email fields? 2
column filter 1

Top