View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Isis[_2_] Isis[_2_] is offline
external usenet poster
 
Posts: 51
Default VBA - copy cells from one sheet to another

I want to copy from a sheet with data on to another empty sheet - I want to
loop through the rows of the first sheet one cell at a time, then write the
contents into the second empty sheet one cell at a time - I will be looking
to manipulate the data slightly before writing it back.

What I am asking for is the code to loop through the first sheet and the
code to write to the second, one cell at a time but also producing the same
number of rows in both sheets when finished - if that makes sense.

Thanks for any help