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
