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.