View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Bill is offline
external usenet poster
 
Posts: 390
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