What I usually do is use the macro recorder to record the steps. If "All of the different items mentioned are already created..." turn on the marcro recorder then do them in the order you want them to happen. Here's a minor tutorial on the marcro recorder: http://www.helpwithpcs.com/tipsandtricks/microsoft-excel-macro-tutorial. htm And another on using VBA: http://www.exceltip.com/category.html#6 And here's how to create your first macro and lots of other good reference: http://www.anthony-vba.kefra.com/vba/vbabasic1.htm -----Original Message----- From: Joyce West [mailto:joywestuk@xxxxxxxxxxx]=20 Sent: Tuesday, May 10, 2005 03:00 PM To: mso@xxxxxxxxxxxxx Subject: [mso] simple macros Can anybody recommend a good article on creating simple macros for Excel (and Word maybe). I wish to create a macro in Excel that will read a front page where details of a customers order, and various delivery dates etc have been entered, that will automatically *print a fax to the distributor with details of requirements *Print large pallet cards (the number of cards determined by the front page entered details. *print a delivery ticket to the customer and dated *print out a copy sheet with all of these instructions recorded. All of the different items mentioned are already created on worksheets within the workbook with various blank sections for the entered details. I am using Excel 2000 Totally unable to get to grips with MS Help and could do with a decent tutorial sheet. Any help would be appreciated Norman West I really cannot get to grips with MS help page and really feel that=20 =09 ___________________________________________________________ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com ************************************************************* 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 ************************************************************* ************************************************************* 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 *************************************************************