Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI ALL,
I have 7 tabs..I want to show link of tabs when I am going from 1 tab to another..
for eg.
If I am going from tab 1 to 3.....I want to show 1->3 in tab 3
If I am going from tab 5 to 3.....I want to show 5->3 in tab 3
Can anyone know how to do this?
Hi, you could add a trigger to each of your sheets that will set the value of some variable with the sheet number you are leaving then use the =getactivesheetid in a text box on each of your sheets.
I have attached an example of this working.
Thanks
Steve
Thanks steve...Its working fyn