Forum Discussion
Kaji_Shoohel_Rana
Oct 22, 2021Copper Contributor
How to Duplicate and rename a sheet according to another sheets entire column value range in vba?
HELP!!! HELP!!! HELP!!!
Here I attached 3 screenshots.
1st sheet column A will be used for
- how many number of sheets sholud be created (A3 to the end)
- Newly created sheets name will be column A's row value from A3 to end.
- 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.
No RepliesBe the first to reply