Metalfreack
New Member
- Joined
- Jul 25, 2016
- Messages
- 1
Hi all,
I was wondering if you know if there is a formula to make crossreferences so that if you click on it that you go to the other crosreference. For example:
I have an excell sheet with 4 tabs. On the first tab i have in cell b2 a number ad this is the same number as in tab 2 d100. So i wana make a button in tab 1 , c2 that if i click on it, i'll go automaticly to tab 2 d100. To show that those two numbers are the same.
This would be helpfull because for my work I need to show sometimes were the information comes from with a crossreference. (We ref onlu with tabs) but then sometimes they have to search within the information in the tab. And if i could show where the info came from by giving them a kind of show reference button, that would be really great!
I hope i stated my question clear, if not do not hesitate to ask more information
! Thanks in advance.
I was wondering if you know if there is a formula to make crossreferences so that if you click on it that you go to the other crosreference. For example:
I have an excell sheet with 4 tabs. On the first tab i have in cell b2 a number ad this is the same number as in tab 2 d100. So i wana make a button in tab 1 , c2 that if i click on it, i'll go automaticly to tab 2 d100. To show that those two numbers are the same.
This would be helpfull because for my work I need to show sometimes were the information comes from with a crossreference. (We ref onlu with tabs) but then sometimes they have to search within the information in the tab. And if i could show where the info came from by giving them a kind of show reference button, that would be really great!
I hope i stated my question clear, if not do not hesitate to ask more information
! Thanks in advance.
