Direct Data Entry into MS Excel Dashboards by Performance Management Innovation

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,099
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on May 11, 2010

Looking at adding data directly to an MS Excel Dashboard. This can either be done using a data table or by using a data entry form. Feel free to email me at jed.shields@performancemi.co.uk to discuss any aspects of this video.

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (JedShieldsPMi)

  • Yeah, there's a little bit of code that copies the inputed data, then finds the next empty line in the data table, pastes the data then finally clears the green boxes ready for the next record. All the rest is using standard excel stuff like drop down boxes, sumproducts, vlookups etc.

see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • Does any of this involve VBA?

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more