I have the file stored on Google Docs at: https://docs.google.com/leaf?id=0B2wwdgJj4ncpYzQ0MTFiNzQtNDAxMi00NGNmLWIzMjMtYmM0NjQyNTY3Y2Nm&hl=en&authkey=CLjt6zY
On Feb 23, 4:01 pm, Ken Hansen <k.e.hanse...@gmail.com> wrote: > Hi all, > > I have a Sales Tracking workbook. I have 2 issues that I can't seem to > resolve. > > 1. When the UserForm to add sales is closed I want all sheets to > refresh. I am using: > > ActiveWorkbook.RefreshAll > > It refreshes everything EXCEPT the Sales Analysis sheet. I have to > manually refresh the Pivot Table on this sheet (oddly the Commission > Analysis Pivot refreshes fine). Can anyone tell me what I can do to > fix that? > > 2. I want to make a UserForm to append existing sales. I would like it > to populate a list of Customer Names (combo or list box) then based on > that selection a second list is populated with the items each customer > purchased. Once the preferred Customer/Item combination is selected, I > would like to be able to fill in a field for Commission amount paid > and the date it was paid on. Once entered on the form it needs to > enter the amount paid on the correct record on the Commission > Worksheet. > > It currently allows manual input in the commission cells, then you can > refresh and it's all OK. I am trying to make it goof-proof, so any > sales rep can enter from a form and accurately track performance. > > I will upload this to files as saleslog.xlsm > > Thanks in advance, > Ken -- ---------------------------------------------------------------------------------- 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