Thank you dguillett!!
I'm not real sure how this works or what to do with it. Could you please
explain to me each step in "baby talk" ?
Thank you!
Steve
------------------------------------------------------------------------
On 9/10/2011 10:31 AM, dguillett1 wrote:
From what I can see, it appears that Very easy to just use a simple
Autofilter on ONE sheet with the proper SELF ADJUSTING subtotal formulas.
=SUBTOTAL(109,(H3:OFFSET(H3,MATCH(9999999,H:H),0)))
See attached
-----Original Message----- From: Steve Weaver
Sent: Saturday, September 10, 2011 6:40 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help with advance filter
Hi,
Every month I download a single commission file which contains between 3
- 4 representatives. Currently I copy and paste the data for each rep
into a unique work sheet so that the appropriate reports can be produced.
I tried using advanced filtering but could not get the desired results.
To write a MACRO to do this is beyond my technical ability.
I'd like to find a way using either a macro OR advance filtering to do
this work for me.
Please send suggestions.
Thank you!
Steve
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
