Need macro code for copying some data from one sheet to another

[PrinceOfCalcutta]

hello, I need to copy some data from one sheet to another.

Suppose, Sheet A is having multiple column; out of that I need to copy column2, column6 and column8 data to another Sheet B to its column 1 ;column2; column3.
Please give me a detailed step to execute the code...as I am very new to this and trying to implement something similar to this problem.

Thanks in advance.

 

[Chris Macro]

Here's the code I would paste inside a module in your workbook. If you need a quick intro to VBA you can click the link in my signature to learn how to add this code to your workbook file. Let me know if you still need help.

<font face=Calibri><SPAN style="color:#00007F">Sub</SPAN> CopyMacro()<br><br><SPAN style="color:#007F00">'Range to Copy in First Sheet</SPAN><br>  Worksheets("Sheet1").Range("B:B,F:F,H:H").Copy<br><br><SPAN style="color:#007F00">'Paste To Second Sheet</SPAN><br>    Worksheets("Sheet2").Range("A1").PasteSpecial<br>    <br><SPAN style="color:#007F00">'Clear Clipboard</SPAN><br>  Application.CutCopyMode = <SPAN style="color:#00007F">False</SPAN><br>  <br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[PrinceOfCalcutta]

Here's the code I would paste inside a module in your workbook. If you need a quick intro to VBA you can click the link in my signature to learn how to add this code to your workbook file. Let me know if you still need help.

Sub CopyMacro()

'Range to Copy in First Sheet
**Worksheets("Sheet1").Range("B:B,F:F,H:H").Copy

'Paste To Second Sheet
****Worksheets("Sheet2").Range("A1").PasteSpecial
****
'Clear Clipboard
**Application.CutCopyMode = False
**
End Sub

Thanks a ton!! I have visited your page...Can you please share your contact number to my mail so that I can discuss my requirement in detail..apu.chakrabarti@gmail.com