View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
hsg hsg is offline
external usenet poster
 
Posts: 40
Default paste to different rows on different dates

Works ! :-)

Thanks

"hsg" wrote:

I want to update sheet1 every day with row data. Each row means one day.
The data which is to be pasted in today (say row10), comes from
Sheet2(say B2:H2). This data (B2:H2) gets updated during working hours,
and I have final figures at the end of day.
Once I have final figures, I want to paste them into Sheet1 every day,
in a manner that if today's data goes to row10, tomorrow's data should
go to row11, and so on.
Column A in sheet1 contains date.

Please help