New to VBA - Copy paste template if cell contains certain value

[New_Excel_VBA_User]

Hi everyone,

This is kind of like asking someone to tell me about the Universe, but i'm new to VBA and have been looking into it more (purchasing books) to get started as I'm seeing a massive need to help with my daily job functions. One I'm primarily looking at is trying to copy a template worksheet and renaming based on (Column A) if Column (AN contains "Yes"); this is updated on a monthly basis so I would also need to have it not attempt to replace a tab or use the name if it already has created a tab. So my questions are is this task possible? What would be the best way for a newbie to start?

Thanks.

 

[New_Excel_VBA_User]

Thank you so much. I'll give this a shot. Thanks a ton!!!!

 

[New_Excel_VBA_User]

I'm getting a compiler error "only comments may appear after End Sub" and it is highlighting the following (sorry my ignorance on the subject I'm not sure what to modify).

Private Declare PtrSafe Function FindWindow Lib "user32" Alias "FindWindowA" _
(ByVal lpClassName As String, _
ByVal lpWindowName As String) As Long

 

[CSmith]

Try this file...

 

[New_Excel_VBA_User]

WOW!!! Y I appreciate the help. VBA language is very different for me (sql and ACL syntx experience) so it looks very different to me and I couldn't have done this yet.

Thanks!

 

[CSmith]

WOW!!! Y I appreciate the help. VBA language is very different for me (sql and ACL syntx experience) so it looks very different to me and I couldn't have done this yet.

Thanks!

Welcome! Glad to help!

 

[New_Excel_VBA_User]

Sorry one last question; when adding to the file and the copy of the template is created and named ActiveSheet.Name = "newSheetName" is there a way to modify to name based on column A in the input data tab? ActiveSheet.Name = worksheets."Inventory".Range(A:A) or would that not work?

 

[CSmith]

It already does by the name passed to that function which is copySheet(Cells(Target.Row, 1)) that 1 = Column A

 

[New_Excel_VBA_User]

Cool. I'll look back and try again, i may have did something as its currently renaming all of mine to Template (1), (2) etc.
Thanks again for all the help!