COPY PASTE AS PER CELL VALUE

[venumkd]

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.

 

[venumkd]

Sir

After replacing the line it shows the Error as

Duplicate Declaration in current scope,

Screenshot attached

 

[Yongle]

remove that line

 

[venumkd]

Sir
Which Line & then what?

 

[Yongle]

the one highlighted in your picture in post#11

 

[venumkd]

Sir
Line removed.
Now the column widths are maintained, but the row heights are not being maintained
Screenshot images are attached

 

[Yongle]

Your latest picture shows that your data contains merged cells
- merged cells cause many challenges for VBA
Plesae supply sample data
XL2BB is tool provided by MrExcel to help you do that
It can be downloaded from here:

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com