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

  • Hali: Closed
  • Zawadi: $50
  • Wasilisho Zilizopokelewa: 2
  • Mshindi: lherreraz

Maelezo ya Shindano

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.

Ujuzi unaopendekezwa

Winner
Shindano Lililohusishwa
Tuma Shindano kama Hili

Bodi ya Ufafanuzi ya Umma

Bado hakuna jumbe.

Jinsi ya kuanza kwa kutumia mashindano

  • Chapisha Shindano Lako

    Chapisha Shindano Lako Haraka na rahisi

  • Pokea wasilisho nyingi

    Pokea Wasilisho Nyingi Kutoka kote ulimwenguni

  • Tuza wasilisho bora zaidi

    Tuza wasilisho bora zaidi Pakua faili - Rahisi!

Tuma Shindano Sasa ama Jiunge nasi Leo!