Solved Excel worksheets auto send?

April 22, 2013 at 14:18:24
Specs: Windows 7
excel worksheets
Is there any way to have excel take you to a specific worksheet when you click on a cell. for instance, if I had cells with Sunday, Monday, Tuesday, etc., and corresponding worksheets with the same names. Can I make it so that, when you click on the Monday cell, it automatically takes you to the Monday worksheet

See More: Excel worksheets auto send?

April 22, 2013 at 16:04:29
✔ Best Answer
What your looking for is the =HYPERLINK() function.

Try this:

With your Sheet Names in Column A:

1) Sunday
2) Monday
3) Tuesday

In Cell B1 enter the formula:

=HYPERLINK("#'" & A1 & "'!A1", "Link To "&A1)

Drag down.

Now when you click the link in Column B,
you will be taken to the new sheet,
with the cursor in cell A1


Report •

April 29, 2013 at 17:55:25
Thanks. This is exactly what I was looking to do.

Report •
Related Solutions

Ask Question