Function for visible cells only


D

deniseandgavin

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.
 
Ad

Advertisements

R

Roger Govier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top