Hi need a macro which would browse to a location (local drive) and load multiple sheets on a workbook based on a user selection (single or multiple sheets) of extension (.xlsx only) and rename them in serial order with prefix "D-"
Example : D-1, D-2, D-3 and so on
If there already exist sheets in workbook with the similar name then it would delete the existing ones.
Any help would be highly appreciated.
Thanks![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Example : D-1, D-2, D-3 and so on
If there already exist sheets in workbook with the similar name then it would delete the existing ones.
Any help would be highly appreciated.
Thanks
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)