Hi
Take a look at Advanced Filter instead of Autofilter.
Try extracting the data to another sheet - any unwanted columns can be
hidden.
You can create a macro to automate the procedure.
For more help take a look at Debra Dalgleish's site, and download some of
her sample files to get you started.
http://www.contextures.com/xladvfilter01.html#ExtractWs
--
Regards
Roger Govier
wrote in message
...
I have tabulated data that has filters applied.
I have another template that create vouchers from this data. Is there
a formula I can put into the fields in the voucher template that will
only retrieve visible cells from tabulated data.
For example I might filter on arrival date in the tabulated data and
only want the visible cells to reflect on the voucher template.
I know the subtotal function can sum only visible cells... I also
have text in the tabulated data that needs pulling through to the
voucher template, plus I donlt need to subtotal anything.
Thanks for any help.