Thread: Copy/paste/sort
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JockW JockW is offline
external usenet poster
 
Posts: 32
Default Copy/paste/sort

Sheet2 has data in cols A-F which are ordered in numeric order by colA. More
rows of data are added weekly.
I would like code which will copy all the data from Sheet2 and paste it to
Sheet8 (overwriting anything already there) and sort it in ascending order by
column C.
Rows 1 and 2 of both sheets are constants (headings) and therefore can be
omitted fron the copy/paste ranges.
Many thanks,

--
tia