Excel 2007 Link worksheets with button

Microsoft Excel 2007
February 5, 2010 at 12:09:09
Specs: Windows Vista, EXCEL
I wanted to know about how to link worksheets using a button. I have made all the buttons and all the sheets. I just need to know how to link the buttons and the sheets together. I have tried assigning macros but it doesn't work properly. When I click run macro,I DON'T KNOW WHAT TO DO TO MAKE THE LINKS BETWEEN SHEETS.
pLESE REPLY

See More: Excel 2007 Link worksheets with button

Report •


#1
February 5, 2010 at 14:15:43
Hi,

You haven't said anything about what you are trying to link to what.

For example
If you have two worksheets in one workbook, Sheet1 and Sheet2:

If you have "Help" in cell A1 on Sheet2
and then put this formula in cell A1 on Sheet1,

=Sheet2!$A$1

Cell A1 on sheet 1 will show "Help"
There is now a link between the worksheets.
Change the word Help in cell A1 on Sheet2 to the number 911 and cell A1 on Sheet 1 will show 911

or are you trying to do something entirely different!

Regards


Report •
Related Solutions


Ask Question