View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Moore[_2_] Rob Moore[_2_] is offline
external usenet poster
 
Posts: 1
Default 'Loop within a Loop'

I am familiar with and use loops on a regular basis but have run into
something I can't figure out.

What I am trying to do at a high level is copy data from one worksheet (old)
to a different worksheet (new).
In 'old' worksheet if column k in any row equals X then copy and paste the
data from columns c,d,e,f of that same row to the same location (row and
column) in the 'new worksheet'.
I started to create a loop to copy data if column K equals X but not sure
how to paste data over to 'new' worksheet.

Thanks in advance for any assistance,
Rob