macro problem

[Gerbatin]

I have a workbook with some similar worksheets, filled from A:6 to M:19(some worksheets could go beyond line 19); I would like to build a macro aiming at copying C:19:M19(other worksheet maybe from C25:M25 for example) to C:22:M22(other worsheet to C25:M25); next refresh(day after) new values should be copied to C:23:M:23 and repeating new values day by day in successive lines from C: to M: (24,25,26.......). I tried to record it unsuccessfully. Excel 2002.I hope I could be understood.

TIA

[aydeegee]

Hi Gerbatim

How will the computer decide whether to copy from C19:M19 or C25:M25 ? (Is it the last row that is being copied?

When it copies to C to M (24,25,26) will the row to be copied to be the last row? If not, what happens to the data lower than the row to be copied to?

Regards
Alastair

[Pepe Le Mokko]

The post being 8 years old, I doubt the OP still follows it...

[aydeegee]

oops - where did hat come from ??? I didn't notice the date!

Alastair