Add work sheet, find and replace macro help!

I want to create a macro to add a work sheet and find and replace


For example

I have a sheet called Template
and a sheet called OP_ALC among hundreds of others


When I click my macro I want to select OP_ALC

Create a new sheet called OP_ALC_TC

So just add the _TC for any sheet

I want OP_ALC_TC to have Template!A1:T3 in there
Then I want to find and Replace VARIABLE with OP_ALC


Any Idea how to do this?
Im still learning how to code and almost have it but no luck

I want to Make OP_EXAMPLE_TC


so copy paste the template and Replace "Variable" With OP_EXAMPLE


Also play Make all make the Cell Number format to General instead of Text


Thanks a bunch!

Try this:

Please Login or Register  to view this content.

No man, I want to create OP_EXAMPLE_TC not TEMPLATE_TC

I want to copy and paste the template into OP_EXAMPLE_TC
and then replace the word "variable" with "OP_EXAMPLE" in the forumula

Edited code to change replacement value to inputted sheet name. Run code and put OP_EXAMPLE in the input box.

Please Login or Register  to view this content.

ok For example

I have SheetX which is a set of data

I also Have a "Template" Sheet

When I am in SheetX

I want to cliick my macro to create a new worksheet called SheetX_TC with Template A1:T3 in it

And In each individual cell formula in SheetX_TC to change from "Template!...." to "SheetX!..."

Let me know if im not being Clear

Perfect Thanks!