View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul Robinson Paul Robinson is offline
external usenet poster
 
Posts: 208
Default Move columns of data from one worksheet to another in open WB

Hi
Can you expand on your etc a bit? If there is a pattern to what is
copied to where it can be done in a loop. If not, some other method
will be better.
The code should be easy either way, but I don't fancy having to solve
the problem twice!
regards
Paul

On May 12, 2:54*pm, George wrote:
Good Day,

I have a open workbook with multiple worksheet tabs, on "Tab 9" I need to
move the entire contents of Column "A" to Column "A" of "Tab 2", Column "B"
to Column "D", etc...

Can someone help direct me with the VB code to perform this task.

Thanks You in advance
George