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
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
