Forum Discussion
Solved
Autopopulate cells based on different sheets using drop down
Hi, I'm wanting to have a home page that users can use a drop down on to display 'final value data' from different years (user selects 2019, it populates with 2019 data). I have seperate sheets f...
If you have a drop-down with the sheet names, you can use
=INDIRECT("'"&dropdown_cell&"'!cell_address")
If you have a drop-down with the sheet names, you can use
=INDIRECT("'"&dropdown_cell&"'!cell_address")- Thats it! Thanks so much 🙂
