Forum Discussion
How to make auto populated cells change accordingly when I select from a drop-down menu?
Hi, I have a template I am working on with many sheets. I am working on tweaking a dashboard sheet "Contacts Tracker Dashboard" based off data in another sheet "Contacts Tracker Database". I ha...
So sorry for the delayed response! Thanks so much for the advice! So, it seems that there has to be a source data table that can be edited and the solution dashboard has to be linked and won't be editable. The XLOOKUP formula also seems to produce similarly to the QUERY formulas I was using before for that kind of outputs. Do you recommend one over the over?
In all it was super helpful! Thanks so so much!
