exwarrior187
06-30-2009, 01:55 PM
I have what seems like a simple vba script that I've been trying to write to perform what seems like a simple set of tasks.
I have 3 worksheets in a workbook, "template", "vlookups", and "list". My objective is to take a value from the first column of the "list" sheet, put it into a specific cell in the "vlookups" sheet (which populates the rest of this sheet), copy it, create a new worksheet named for the value passed from "list" to "vlookups" and paste the values and formatting and then go back to the "list" sheet and continue the before mentioned steps while moving down the first column . The "template" sheet is really just there and I'm not doing much with it, in fact it looks exactly like "vlookups" but it is blank.
i'm really hoping that the expert who decides to field this will "teach me to fish", instead of "catching me a fish". Sadly I've been trying to use the Macro Recorder to get me started on the scripting. :( Many thanks in advance.
I have 3 worksheets in a workbook, "template", "vlookups", and "list". My objective is to take a value from the first column of the "list" sheet, put it into a specific cell in the "vlookups" sheet (which populates the rest of this sheet), copy it, create a new worksheet named for the value passed from "list" to "vlookups" and paste the values and formatting and then go back to the "list" sheet and continue the before mentioned steps while moving down the first column . The "template" sheet is really just there and I'm not doing much with it, in fact it looks exactly like "vlookups" but it is blank.
i'm really hoping that the expert who decides to field this will "teach me to fish", instead of "catching me a fish". Sadly I've been trying to use the Macro Recorder to get me started on the scripting. :( Many thanks in advance.