View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael M Michael M is offline
external usenet poster
 
Posts: 118
Default Copy and Paste data

Hi All
I am trying to write a Macro that will allow me to copy all data in Sheet 2,
in the range A6:F6 down to the last line of data, which changes in length
each day.
I then want to clear all cells in range B12:G12 down to the last row, which
changes each day, on Sheet1 and paste the data from Sheet2.
Any help suggestions would be greatly appreciated.
Thanks in Advance
Michael M