Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
96
Views
Topic starter
Good Morning,
I'm sure I'm asking a really simple question but currently I'm struggling to reference a cell value from a separate worksheet contained in a query.
I'm trying to add a value from 'MTD Site' worksheet into a textbox located in 'Main Menu' worksheet. I'm currently creating my first dashboard.
Any help greatly appreciated..
Andy
Posted : 31/12/2021 7:49 am
Hi Andy,
If you want to add a text to a textbox, just select the textbox then go to formula bar, type the = sign then select the cell from the other sheet and press enter.
When you select the textbox, the formula bar should show the formula to the linked cell, like: =Sheet2!A1
Posted : 01/01/2022 5:21 am
