Hello,

I am looking for some help in getting data from one sheet to another based on a date entry.

On sheet1 column h1:h10 sums rows b2:b10 to g2:10. I want to copy and paste the results only (paste special) to sheet2 in a column appropriate to the date on sheet1 (cell a1) to the column on sheet2 that has the same date. eg sheet1!a1 may be 8/11/04 and sheet2!c1 would be 8/11/04 the data from h would copy to c2:c10 then on another date say 15/11/04 hsheet1!h would copy to sheet2! d2:d10.

This could be done on the press of a button, save or another way if suggested.

Many thanks Stephen

if you go TOOLS/MACROS/Record New Macro you can record a new macro as you copy your stuff, then modify the macro so that it works they way you want.

Hope this helps
Chi

"They mostly come at night...mostly"

I tried using the RECORD MACRO, but on the LOOP to go to the next name on thr first page, the first name stays in the recorded macro. I´m trying to go down a name list on the first sheet and access the same nae on the second sheet and copy some detailed information there, so as to paste it on the first sheet. Help !!!!