Forum Discussion
need help with microsoft excel dashboard
i am working on excel, and i want to create a VBA for below i have following sheet names: 1. QA Dashboard 2. Emirates 3. TA 4. AMEX 5. Spotify 6. SA 7. McCamm 8. Honda 9. Energizer 10. Acc...
Sry but since I don't have much time at the moment, I'll send a simple and quick example to Emirates. You can convert the other buttons as well, just need to delete the hyperlinks.
- Sorry I'm late to this conversation but wondering if you might be able to use a NON macro solution, which would also work for using Excel Online. Depending on what is on and what you need to do in those other tabs. For example if it is just information and comparison values (i.e. not data entry) then you could instead just use the QA tab as the reporting tab that will display the information from the other tabs. Instead of links I would use a drop down (Data Validation) and then a formula to 'pull' the data from those other tabs to show the user the data from that tab on the QA tab. If this type of solution might work for you I would be happy to help you do that.
- Het thanks a lot
this solved my issue 🙂
