Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Performing a function on visible cells only in a range | Excel Discussion (Misc queries) | |||
Sum of visible cells only | Excel Worksheet Functions | |||
can i sum up only visible cells? | Excel Worksheet Functions | |||
In Excel - a function or operation for "view visible cells" | Excel Discussion (Misc queries) | |||
Visible cells | Excel Worksheet Functions |