Need vba code to update pivot chart to show data closest to date entered in input box

• Status: Closed
• Prize: $50
• Entries Received: 2
• Winner: lherreraz

Winner

Contest Brief

I have set up a datamodel to produce several graphs in a sheet. . I need a code written to make the graphs automatically update to show the most recent data to the date shown in cells I1 for MBN and W1 for GRV. (the filter buttons on the chart must be hidden so this needs to be worked into the code)

I also need my email Report code update so it ask the user whether it wants to send a MBN or GRV report and then export either the GRV or MBN report (on separate pages of the same work sheet) following the code I have written based on the users selection.

Recommended Skills

• Charts
• Excel
• Excel Macros
• Excel VBA