Dear 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 worksheet in Column A starting 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.
At the same time the row counts of the copied sheets also to be set as per the values given in Column C starting from cell C1.
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 worksheet in Column A starting 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.
At the same time the row counts of the copied sheets also to be set as per the values given in Column C starting from cell C1.
Thanking you, yours faithfully
VENU P.K.
