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
|