Sirs
I need an Excel VBA / Macro for the following function. This is for a Data Entry Work.
I am having a worksheet containing 3000 worksheets in which 1500 sheets are having contents done manually. These contents are to be copied to other sheets without changing cell formats.
The sheet names to be copied shall be mentioned in Sheet1 of the same workbook in Column A starting from cell A1 to downwards. The sheet names where to copy also shall be given in the same sheet in Column B starting from Cell B1 to downwards against each corresponding Sheet names in Column A.
Thanking you, yours faithfully
VENU P.K.
I need an Excel VBA / Macro for the following function. This is for a Data Entry Work.
I am having a worksheet containing 3000 worksheets in which 1500 sheets are having contents done manually. These contents are to be copied to other sheets without changing cell formats.
The sheet names to be copied shall be mentioned in Sheet1 of the same workbook in Column A starting from cell A1 to downwards. The sheet names where to copy also shall be given in the same sheet in Column B starting from Cell B1 to downwards against each corresponding Sheet names in Column A.
Thanking you, yours faithfully
VENU P.K.