Repetetive summing, every 7 days

damone

New Member
Joined
Oct 2, 2006
Messages
1
I wish to copy 7 days worth of data from sheet one and paste to sheet 2 and repeat every 7 days(Columns) I know this is easier than I ammaking it but I am stumped and would appreciate some help.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi, damone
Welcome to the Board !!!!!

let's presume you want to change the layout ... else you wouldn't just copy the data 7 by 7
how would that look like ?
(I can imagine it but you are the one who is asking)
care to provide an example


kind regards,
Erik
 

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,634
Members
410,804
Latest member
bluepinky
Top