Hi. First of all I apologise if this has been covered already. I have spent hours looking at various solutions which are similar to what I want, but not exactly right, and I am an Excel novice so I am not able to modify other code.
I have a workbook with two worksheets. For argument's sake they are called Blue and Green. "Blue" is the sheet where the user inputs some basic data (their name, date of birth etc). Green is a template form. I am trying to set up the following process: 1. User selects a month of the year from a drop-down list on "Blue" 2. User hits a button 3. Excel generates a copy of "Green", places it at the end and renames it according to the month the user selected in the drop-down box. I would be grateful for any help! --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
