New sheet and adding columns

[Sohels2]

I need a macro that will copy the sheet "Template" and create a new sheet with a defined name. Furthermore, I want the macro to create a column in the "0-PURCHASE AMOUNT" sheet with the defined name and apply the formula similar to the one in "Template" Column for that respective sheet. Also, I want the macro to add the vendors name, which is the new sheet name in the "0-Running Balance" sheet and add the amount for running balance. The amount will be the very last entry in Column K in the template or the respective vendor sheet.

So far I was able to come up with the following code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please help me complete this macro and make it one single macro for all the tasks. I am attaching the excel file for reference.

Thank you

[arlu1201]

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

[arlu1201]

I need a macro that will copy the sheet "Template" and create a new sheet with a defined name. Furthermore, I want the macro to create a column in the "0-PURCHASE AMOUNT" sheet with the defined name and apply the formula similar to the one in "Template" Column for that respective sheet. Also, I want the macro to add the vendors name, which is the new sheet name in the "0-Running Balance" sheet and add the amount for running balance. The amount will be the very last entry in Column K in the template or the respective vendor sheet.

I understand the part that you need a prompt for the sheetname. How many times should the template sheet be copied? Just once?

Explain this part - I want the macro to create a column in the "0-PURCHASE AMOUNT" sheet with the defined name and apply the formula similar to the one in "Template" Column for that respective sheet.