I would like to know if there is anyway when someone selects a value from an array on one worksheet to pull data, create chart from another worksheet - then display on the worksheet where the array resides
I have attached spreadsheet - array and display needs to happen on the worksheet named Dashboard --- data for chart resides on Historical Data worksheet
Bookmarks