Using this YouTube video as a guide https://www.youtube.com/watch?v=lCsvSdk4Tro I have created a Dashboard of sorts which has a Dropdown box and this shows data from numerous sources.
The sources are mainly Pivot Tables but is there a way to actually edit whatever is being shown in the Camera window?
For instance, my Pivot Table has a Filter for Dates but because the Camera window is a static snapshot there's no way for the user to edit.
Of course I could just created lots of sheets corresponding to each month but is there a more dynamic way to do this?
The sources are mainly Pivot Tables but is there a way to actually edit whatever is being shown in the Camera window?
For instance, my Pivot Table has a Filter for Dates but because the Camera window is a static snapshot there's no way for the user to edit.
Of course I could just created lots of sheets corresponding to each month but is there a more dynamic way to do this?