G
grlong
I have several rows of highlighted data, I would like to filter and print
only the highlighted rows
only the highlighted rows
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.
B
Bob Phillips
If you mean highlighted by colour or conditional formatting, see Ron de
Bruin's EasyFilter add-in at http://www.rondebruin.nl/easyfilter.htm
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
Bruin's EasyFilter add-in at http://www.rondebruin.nl/easyfilter.htm
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
G
grlong
Oh my goodness! I have been trying to do this without success
and from your response it took me less than 5 minutes
Thank you
and from your response it took me less than 5 minutes
Thank you
M
mkirkwag
Any methods that don't involve installing anything? Most of us working in
major corporations aren't allowed to install.
major corporations aren't allowed to install.
P
Pete_UK
If the highlighting comes from conditional formatting then you can
apply the same CF formula in a helper column to return TRUE or FALSE,
and then apply the filter to this column. If the colouring is done
manually, and you are not allowed a macro to read the colour, then you
will have to manually enter a code (Y/N ?) in the helper column and
then filter on this.
Hope this helps.
Pete
apply the same CF formula in a helper column to return TRUE or FALSE,
and then apply the filter to this column. If the colouring is done
manually, and you are not allowed a macro to read the colour, then you
will have to manually enter a code (Y/N ?) in the helper column and
then filter on this.
Hope this helps.
Pete