Re: [ExcelVBA] Macro to copy info from one shet to another

 

I have tried the filters and they work fine with the exception of "totals".  I have a column separate from the initial data that keeps a running total of each sales person.  However, when I filter to a salespersons initials, the totals can't be seen.  In one respect, that is good because they are no longer allowed to see what the other sells.  The downside is that they can't see their own either.

I have this snip of code that allows me to see the total for KB in cell H3.

' KBTotal Macro
'

    ActiveSheet.Range("A4:G250").AutoFilter Field:=2, Criteria1:="KB"
    ActiveSheet.Range("H3").Value = Application.SumIf(Range("B5:B250"), "KB", Range("C5:C250"))
        Range("H3").Select
End Sub

Is there a way that the total for each person respectively can appear in H3 if that person is selected in the filter?

Thanks for your help and suggestions. 

Sharron

__._,_.___

---

Posted by: sheizageek@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (7)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___