View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sanju[_2_] sanju[_2_] is offline
external usenet poster
 
Posts: 18
Default Copying and pasting values to the last available column

I need to update daily stautus to the particular column of the
worksheet. Now these values are updated daily in column 22 of
worksheet.
For today , copy values of acolumn 22 to EA.
tomorrow, copy values of column 22 to EB
day after , copy values of column 22 to EC and so on

regards
sanjay