Thread: Move contents from one tab to another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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



Reply With QuoteReply With Quote