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