P.S.
It helps if your reply contains previous messages, makes it easier to follow
what has been said before...
thanks...
--
steveB
Remove "AYN" from email to respond
"STEVE BELL" wrote in message
news:X0%ye.20445$H64.19763@trnddc07...
Without seeing your workbook, it is hard to give you code or hard advice.
But here are some sites where you can get all kinds of code and helpful
advice:
http://www.cpearson.com/excel.htm
http://www.contextures.com/index.html
http://www.peltiertech.com/index.html
http://j-walk.com/
http://www.appspro.com/
http://www.rondebruin.nl/tips.htm
www.tushar-mehta.com
http://www.xldynamic.com/source/xld.html
Macros will do just about anything you do manually, and than much more.
To record a macro:
Select the Tools menu
Select Macro
Select Record Macro
than just start doing stuff.
When you are finished - repeat the above steps but turn off Record Macro.
Now go to the VBE and see what you got. Edit it as needed.
Understand that the recording will use a lot of Selection or Selection -
most code doesn't need that.
You can work directly with workbooks, worksheets, ranges, cells without
selecting (most of the time).
Buttons usually have a macro assigned to them and when clicked the macro
will run.
Keep using the group to get further info. Monitor some of the messages to
see how people are doing things - there's great stuff here... and the
people are super...
--
steveB
Remove "AYN" from email to respond
wrote in message
oups.com..
Thank you for the reply Steve. I guess I should have said that I am
new to the use of macros. I have always done everything I could to
complete tasks with a combination of functions and have never used
macros before.
So, I have decided to switch to checkboxes because it appears as if you
cannot select multiple radio buttons, but I do not know how to do a
"record macro" in the easy manner you described. I need an update
button to accomplish the task but how do I get the update button to
reference the selected cells and create newly copied sheets?
Thank again,
Johnny