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.
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.
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.
JedShieldsPMi 1 year ago