'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
|