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