Hi angrob

Yes you can.
Take a look at Advanced Filter. You should find plenty of help at
http://www.contextures.com/xladvfilter01.html#ExtractWs
--
Regards
Roger Govier

"angrob" wrote in message
...
I've an Excel Spreadsheet with 6 columns, 1 column which has a question, 4
of
them I add figures to and these are totalled etc, and then there is 1
column
which takes text/comments. I want to know if I can automatically extract
the
text column along with the corresponding columns to another page?

--
angrob