View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ap19 ap19 is offline
external usenet poster
 
Posts: 5
Default Move data worksheet to worksheet

Hello,
I have a worksheet called (Template). I want to move the values in column H
to a new worksheet called (Output) begining from A1 downwards. The results in
column H can be spaced out, for example;
h5 - $150
h6 - $125
h7-
h8- $75
I would like them to have the space removed when transfered to Output
worksheet. Also, everytime the code is run I would like the results from
Template to Append to the last row of data in the Output worksheet. Hope this
makes sense. Thanks in advance for your time.