Function for visible cells only
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. |
Function for visible cells only
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. |
All times are GMT +1. The time now is 06:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com