Move contents from one tab to another
 

What would be the code to move the columns "J" "K" "L" & "M" from one
Tab labeled Invoice to Another labeled Master. They would need to be
moved to the same columns. (Hence J, K, L, & M)

Thanks,

Met


--
Metrazal
------------------------------------------------------------------------
Metrazal's Profile: http://www.excelforum.com/member.php...o&userid=31648
View this thread: http://www.excelforum.com/showthread...hreadid=515410

Move contents from one tab to another
 

Hi

Try this

Sheets("Invoice ").Columns("J:M").Copy Sheets("Master").Range("J1")


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Metrazal" wrote in message
...

What would be the code to move the columns "J" "K" "L" & "M" from one
Tab labeled Invoice to Another labeled Master. They would need to be
moved to the same columns. (Hence J, K, L, & M)

Thanks,

Met


--
Metrazal
------------------------------------------------------------------------
Metrazal's Profile: http://www.excelforum.com/member.php...o&userid=31648
View this thread: http://www.excelforum.com/showthread...hreadid=515410

Move contents from one tab to another
 

Try this:

Sub CopyToMaster()
Worksheets("Invoice").Range("J:M").Copy
Destination:=Worksheets("master").Range("J:M")
End Sub


This makes a raw copy of the whole columns.

If you want to copy values only (formulaes' result) only, or optimize thz
number of cells to be copied, please ask

HTH,

--
AP

"Metrazal" a écrit
dans le message de
...

What would be the code to move the columns "J" "K" "L" & "M" from one
Tab labeled Invoice to Another labeled Master. They would need to be
moved to the same columns. (Hence J, K, L, & M)

Thanks,

Met


--
Metrazal
------------------------------------------------------------------------
Metrazal's Profile:
http://www.excelforum.com/member.php...o&userid=31648
View this thread: http://www.excelforum.com/showthread...hreadid=515410