C
chanceygardener
is the any way to copy, cut or print the list that is availible in a field
when auto filter is used?
when auto filter is used?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Debra Dalgleish
You can't copy the AutoFilter dropdown list, but you can use an Advanced
Filter to extract the unique values from a list. There are instructions
here:
http://www.contextures.com/xladvfilter01.html
Filter to extract the unique values from a list. There are instructions
here:
http://www.contextures.com/xladvfilter01.html
C
chanceygardener
When I follow those instuctions I get an error message that says "You can
only copy filtered data to an active spreadsheet". I thought I was filtering
the data using the steps in the instructions. What am I doing wrong?
only copy filtered data to an active spreadsheet". I thought I was filtering
the data using the steps in the instructions. What am I doing wrong?
D
Dave Peterson
You sure you started the dialog when you were on the second worksheet????
C
chanceygardener
That worked but that is not what the instructions say. the instructions say
"Select a
cell in the database" thanks.
"Select a
cell in the database" thanks.
P
Peo Sjoblom
No it doesn't, nowhere in your previous post did you indicate that you were
filtering to another sheet, you can just see the instructions for the next
example
"Extract Data to Another Worksheet
If the database is on Sheet1 and you would like to extract data to Sheet2:
Go to Sheet 2 <<<<<<<<<<<<<<<<<<<===============================
Select a cell in an unused part of the sheet (cell C4 in this example).
From the Data menu, choose Filter, Advanced Filter. "
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
filtering to another sheet, you can just see the instructions for the next
example
"Extract Data to Another Worksheet
If the database is on Sheet1 and you would like to extract data to Sheet2:
Go to Sheet 2 <<<<<<<<<<<<<<<<<<<===============================
Select a cell in an unused part of the sheet (cell C4 in this example).
From the Data menu, choose Filter, Advanced Filter. "
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com