[mso] Re: Excel Macro
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 4 Nov 2003 10:08:07 -0500
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
*************************************************************
Other related posts:
