Thread: Copy Paste
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
saturnin02[_2_] saturnin02[_2_] is offline
external usenet poster
 
Posts: 36
Default Copy Paste

Hi,
I have a series as such:
Cell A1 =Date Cell B1= value
Cell A2= Date(A1+1 as value) Cell B2=value
etc.

I would like to be able to extract only weekly data (the series is daily)
and have the values in a separate sheet or side by side with the daily
series but with no gaps or spaces--
Cell D1=Date Cell E1=value
Cell D2= (Date +7) Cell E1- corresponding value of D2, etc.

I need to avoid the lengthy cut and paste and "automate" as much as I can
the process.

Any suggestions??
Tx a lot,
S