hello ,
can i ask about how can i when i press on a cell value it shows me the value details from the table on the sheet at background.
Thanks with high appreciate for your efforts.
hello ,
can i ask about how can i when i press on a cell value it shows me the value details from the table on the sheet at background.
Thanks with high appreciate for your efforts.
Hi and welcome to the forum.
I'm struggling to understand your requirement.
What do you mean by 'press on a cell value'? Do you mean select the cell and if so What do you want to happen?
What details should it show?
Why at the moment does it show 1250? Is this something to do with C8 on Sheet1?
If so why not just enter the formula =in B2Formula:![]()
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks Mr. Richard Buttrey , for your support, but i mean that how can i when i press on the cell on sheet2 "Just a value" , its show me some thing like pop up Msg or dynamic hyperlink , to show me what is the Number full details as a table like in sheet1.
actually i didn't see some ting like that before , but my manager ask me to make it in a report . so i ask you for your support
i hope that you got my mind .
Try
in C2
=HYPERLINK("# Sheet1! C" & MATCH(B2,Sheet1!C:C,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks