How to Duplicate and rename a sheet according to another sheets entire column value range in vba?

%3CLINGO-SUB%20id%3D%22lingo-sub-2874113%22%20slang%3D%22en-US%22%3EHow%20to%20Duplicate%20and%20rename%20a%20sheet%20according%20to%20another%20sheets%20entire%20column%20value%20range%20in%20vba%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2874113%22%20slang%3D%22en-US%22%3E%3CP%3EHELP!!!%20HELP!!!%20HELP!!!%3C%2FP%3E%3CP%3EHere%20I%20attached%203%20screenshots.%3C%2FP%3E%3CP%3E1st%20sheet%20column%20A%20will%20be%20used%20for%3C%2FP%3E%3COL%3E%3CLI%3Ehow%20many%20number%20of%20sheets%20sholud%20be%20created%20(A3%20to%20the%20end)%3C%2FLI%3E%3CLI%3ENewly%20created%20sheets%20name%20will%20be%20column%20A's%20row%20value%20from%20A3%20to%20end.%3C%2FLI%3E%3CLI%3EAnd%20the%20row%20must%20be%20in%20the%20new%20sheets.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E2nd%20sheet%20is%20the%20format%20I%20want%20to%20duplicate%20to%20the%20newly%20created%20every%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EResult%20sheet%20will%20be%20the%20final%20result.%3C%2FP%3E%3CP%3EIt%20should%20be%20automated%20by%20a%20button.%3C%2FP%3E%3CP%3EI%20did%20the%201st%20portion%20but%20can%20not%20duplicate%20the%202nd%20sheet%20to%20the%20new%20sheets.%20It's%20urgent.%20Please%20someone%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2874113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

HELP!!! HELP!!! HELP!!!

Here I attached 3 screenshots.

1st sheet column A will be used for

  1. how many number of sheets sholud be created (A3 to the end)
  2. Newly created sheets name will be column A's row value from A3 to end.
  3. And the row must be in the new sheets.

2nd sheet is the format I want to duplicate to the newly created every sheets.

 

Result sheet will be the final result.

It should be automated by a button.

I did the 1st portion but can not duplicate the 2nd sheet to the new sheets. It's urgent. Please someone help me.

0 Replies