Create Button in selected cell

[jrisebo]

I want someway to select a cell, and then create a button in said cell. I want it to be the same size as the selected cell.

 

[jrisebo]

Well, I have seven different tabs that have data. Depending what you choose on a input tab, one of the seven tabs is what does the calculations.
So if on the input tab you pic 'anch4', tab 4 does the calculation. I want to be then able to have a button that based on the input of 'anch4', it takes you to the 4th tab.

 

[GlennUK]

What cell would be tested for 'anch1' 'anch2' etc? And will the actual entries be 'anch1' 'anch2' etc? What are the 7 corresponding tab names?

 

[jrisebo]

Ok, Cell H42 on 'INPUT' tab has a drop down that is A thru F. The calc sheets are 'A Headed studs', 'B Headed Studs','C Headed studs', 'D Headed Studs','E Headed studs', 'F Headed Studs'

So depending on what you pick in Cell H42 on Input, I want the button you click to hyperlink to the correct tab. Thus the If statement, and hyperlink.

It doenst have to goto a specific cell on each tab, just jump to the tab.

 

[GlennUK]

Try this:

=HYPERLINK("#'" & H42 & " Headed Studs'!A1","Goto calcs")

 

[jrisebo]

that works if I just paste in a cell, and click. How do I get it to be associated with a button now?

 

[GlennUK]

Why do you need a button if you have a hyperlink that does exactly the same?

 

[jrisebo]

Just want it to look good, stand out.

 

[jrisebo]

Ok, Got some more. Same thing, just that the tabs for B,C,D are one in the same.

Cell H42 on 'INPUT' tab has a drop down that is A thru F. The calc sheets are 'A Headed studs', 'B,C,D Headed Studs','E Headed studs', 'F Headed Studs'

Thanks

 

[GlennUK]

That would be:

=HYPERLINK("#'" & INDEX({"A","B,C,D","B,C,D","B,C,D","E","F"},MATCH(H42,{"A","B","C","D","E","F"},0)) & " Headed Studs'!A1","Goto calcs")