DarkCrystal
09-22-2008, 10:08 AM
The project I am working on has two sheets. Data from Sheet1 is pulled from data entered into Sheet 2. A user enters info into Sheet2 (named Template) which is an expense report form.
What I am trying to do is create a macro that will copy Template and move the copied sheet to the last sheet. With the copied Template, Template(2), I want the user to be able to fill in Template(2) and have the needed fields sent to Sheet1. There will be several copies of Template with each new expense report filled out, or Template(3), Template(4), ... ,Template(n). The info from Template(3) will go to Sheet1, one row down (next available row), and so on with each new copy of Template created. The fields in Sheet1 are "Purchaser", "Vendor", "Cost", "Code", "Date".
That is it. Wrapping up, by running the macro, Template will be copied to create a new form and the info entered into it will go to Sheet1. Run the macro again and a second copy of template will be created and the info entered will go to Sheet1 into the next row. And so on.
Nicholas
What I am trying to do is create a macro that will copy Template and move the copied sheet to the last sheet. With the copied Template, Template(2), I want the user to be able to fill in Template(2) and have the needed fields sent to Sheet1. There will be several copies of Template with each new expense report filled out, or Template(3), Template(4), ... ,Template(n). The info from Template(3) will go to Sheet1, one row down (next available row), and so on with each new copy of Template created. The fields in Sheet1 are "Purchaser", "Vendor", "Cost", "Code", "Date".
That is it. Wrapping up, by running the macro, Template will be copied to create a new form and the info entered into it will go to Sheet1. Run the macro again and a second copy of template will be created and the info entered will go to Sheet1 into the next row. And so on.
Nicholas