Forum Discussion
Reference/link between sheets
Hi everyone, I am trying to solve an issue creating a reference/link between the excel worksheets. I have multiple sheets with data, as I can´t use the original I have created just a simple example w...
This is not exactly what you were describing, but I've done it just to illustrate what could be done. This isn't as "pretty" as it could be made. For example, we could create the drop down lists so that any one word appeared only once under the "Used" item. We could also put all of that into a "dashboard"...
The idea is that rather than taking you TO the sheet where that data appears, it brings the data to YOU (to the dashboard).
