L LadyDi Registered User. Local time Today, 13:16 Joined Mar 29, 2007 Messages 894 Feb 21, 2008 #1 Is there a way to write a macro so that you can just push a button and find totals of a filtered spreadsheet. I would like to be able to filter a spreadsheet and get the total of just the numbers that are showing. Any ideas on how I can do that?
Is there a way to write a macro so that you can just push a button and find totals of a filtered spreadsheet. I would like to be able to filter a spreadsheet and get the total of just the numbers that are showing. Any ideas on how I can do that?
S shades Registered User. Local time Today, 15:16 Joined Mar 25, 2002 Messages 516 Feb 21, 2008 #2 Howdy. you can do that by using the SUBTOTAL Function, that way you can avoid VBA. But if you want, it can be done. ________ FREE JOOMLA THEMES Last edited: Feb 16, 2011
Howdy. you can do that by using the SUBTOTAL Function, that way you can avoid VBA. But if you want, it can be done. ________ FREE JOOMLA THEMES