Thanks for the attachment , I liked the idea of having a command button do the needful...
Originally Posted by
e4excel
I would prefer that the Range Strats from C2 till Cn so on so forth and not in between as C6 as mentioned in the file..
One more thing How did you get the Labels in Column B6 Sheet 2 Name is this automated via VBA as well? If not can that be done ...
I would appreciate if you could help explain how to change the location to C2 to Cn and also have the labels appear dynamically?
I am no good in VBA to understand the code much?
I understand in this code you have called the below module
What is Worksheets Count?
The purple portion if not mistaken is a For Loop?
In the whole exercise we ar just renaming the Sheet Names dynamically via VBA but can we also Add them including the above?
If yes then can you please help me on the same?
Bookmarks