Go to View>Toolbars>Forms On sheet 1, click on the "button" tool on the toolbar and draw a button, when you release your mouse button, the Assign Macro box will come up...name the button Sheet 2 Then click OK and then Ok again to start recording the macro Once you see the macro recorder toolbar on the screen, click on the sheet tab for sheet 2 to move there, then click on the Stop Recording button Repeat this for all other sheets, then do the same thing for the Standings button Now..the second question...go to the cell in the Standings sheet where you want the info pulled from another cell on another sheet, then type this =( Then click on the sheet tab where the total is, and click on the cell with the total in it and hit enter...now the Standings sheet will refer to that cell and always update when you change it Linda F. Johnson, M.A., MOS Linda's Computer Stop http://personal-computer-tutor.com Free e-Books, Newsletter, and tutorials -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Carr Sent: Tuesday, November 04, 2003 9:13 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Excel Macro Hi Group, I need some help in trying to write a macro for an excel football standings spreadsheet I have. What I have Done: Sheet 1 has all the teams listed in one column and buttons for each week (1-17) across the top. Sheets 2 - 18 represents each week of football. On it it has a standings button and lists the game for the day in one column, next column has the game score and the last coulmn list the game winner. What I would like to do: When I click on the button from the Standings sheet (sheet 1) it takes me to the sheet of that week and when I click on the standings button from any of the weeks within in the spreadsheet it goes back to the standings sheet. Would aslo like when I list the winner in column c of each week the standings sheet will automatically update. What do I need to change/add in my spreadshett for the following to work? Any and all help will greatly be appreciated. TIA, P. ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************