LOL. thanks for ur helP! "Dave Peterson" wrote: I don't understand... But I bet it's possible <bg>. KDP wrote: DAVE, you are the man.! now that i know this is possible.... i have another question..is it possible to alter this somehow to make it work in a similar way but differently... Can i make it create the worksheets

DAVE, you are the man.! now that i know this is possible.... i have another question..is it possible to alter this somehow to make it work in a similar way but differently... Can i make it create the worksheets in ONE workbook (basically create the default file that i would later duplicate for users, has about 25 sheets) and pull from another list (this list will be dates)? -

Dave, everything is working fine... i just have an 'out of curiosity' question. when the workbooks are saved to the file, Instead of having the Excel logo, they have the Windows logo...and they open as excel files. is there any reason behind this? -Kevin "Dave Peterson" wrote: Whew! I was out of guesses. KDP wrote: DAVE IT WORKED!!! it was

DAVE IT WORKED!!! it was just a matter of getting the macro to save under the correct workbook, etc. THANK YOU THANK YOU THANK YOU!!! --------------------------------------------------- "Dave Peterson" wrote: The macro should be in the same workbook as the worksheet that has the list. If there are errors, then this line: Application.Goto ListWks.Range("a1") will show

yeah, that is where the list is located... does it matter when i pull up available macros (Alt+F8) , that the macro isnt stored in "This workbook", it's listed under "All open workbooks" or "personal.xls" --------------------------------------------------- "Dave Peterson" wrote: The code picks up the names from the workbook and worksheet that is specified in this line: