shekhu
10-12-2016, 05:22 AM
Hi All,
Can someone help me create a Macro to copy selected cells in a row (e.g. A TO H) and create new sheet (by copying from a Template Sheet) and paste the copied cells "A to H" at specified locations. Please see attached .xls file for reference.
Also, is it possible to copy contents of a "cell comments" and paste in a new sheet?
Sheets("Template").Select
Sheets("Template").Copy After:=Sheets(2)
Selected Cell("A") Copy to Cells(C4)
Selected Cell("B") Copy to Cells(A10)
Selected Cell("C") Copy to Cells(A7)
Selected Cell("D") Copy to Cells(B7)
Selected Cell("E") Copy to Cells(A4)
Selected Cell("F") Copy to Cells(B4)
Selected Cell("G") Copy to Cells(B10)
Selected Cell("H") Copy to Cells(C7)
Comments in Cell("B") Copy to Cells(B16)
Please Suggest.
Can someone help me create a Macro to copy selected cells in a row (e.g. A TO H) and create new sheet (by copying from a Template Sheet) and paste the copied cells "A to H" at specified locations. Please see attached .xls file for reference.
Also, is it possible to copy contents of a "cell comments" and paste in a new sheet?
Sheets("Template").Select
Sheets("Template").Copy After:=Sheets(2)
Selected Cell("A") Copy to Cells(C4)
Selected Cell("B") Copy to Cells(A10)
Selected Cell("C") Copy to Cells(A7)
Selected Cell("D") Copy to Cells(B7)
Selected Cell("E") Copy to Cells(A4)
Selected Cell("F") Copy to Cells(B4)
Selected Cell("G") Copy to Cells(B10)
Selected Cell("H") Copy to Cells(C7)
Comments in Cell("B") Copy to Cells(B16)
Please Suggest.