Advanced Filtering, Simple question

Dysprositos

Board Regular
Joined
Aug 3, 2002
Messages
92
Im stumped,

I have a list with the labels in the first row. I would like to display certain rows, and later i would like to copy them to somewhere else. I presume i can use the Advanced filter, but i cant work it? I can display the rows i want with the auto filter.

Ive read the help file and i cant see where im going wrong.

Thanks to anyone who can help.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

saon

New Member
Joined
Aug 7, 2002
Messages
16
hi,
what i understood is, you can choose your desired rows with auto filter but you cant copy and paste them to another place (sheet,workbook).

if so, excel has a button but is hidden!!!

right click on the menu bar, select customize,then commands, then "edit toolbar", then scroll down till you see the button "select visible cells". simply drag and drop the button to the menu bar.

is this the answer?
 

Dysprositos

Board Regular
Joined
Aug 3, 2002
Messages
92
Nope, but thanks anyway.

Ive figured it out like this. With advanced filtering, your criteria range can only contain rows with values. If there are rows with no values then the copy method returns the whole list.

It seems obvious, but i manage to find a way of making things confusing.
 

saon

New Member
Joined
Aug 7, 2002
Messages
16
so why dont you simply delete the empty rows? (or sort the data)?
This message was edited by saon on 2002-11-08 03:24
 

Forum statistics

Threads
1,144,438
Messages
5,724,361
Members
422,546
Latest member
KevinOnTheDaily

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top