View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rjamison rjamison is offline
external usenet poster
 
Posts: 45
Default Copy data from Cell to Cell

I am trying to copy data from column D to Column M on the same worksheet.
Orignally I put "=D2" in the M2 and so on. The problem is I must copy the
cells later to another workbook. I get #Ref! in Column M. I need the VBA
code
so that when the workbook opens it permantly copies the data for any row
in
Column D to Column M. There number of rows changes from day to day.
Please
help. Thanks

Bill