how to copy the content of a cell?

[fanch72]

Hi,
The problem is the following. On the first spreadsheet I have a week number and a table containing expenses per day of this week. On the next sheet I want to have a table with the consolidated expenses per week. When I change the week number on the first sheet I want the second sheet to keep the information of the previous week so that at the end of the year I have a second sheet with all data for a year (week after week) and the first sheet is at week 52.
Thanks for the help!!!
Fanch

 

[PepeLeMokko]

Could it be easier to make a list with in colA the date the expenses were made, and the amount in column B
Make a Pivot table of this list and group the dates by week.
This is by far the easiest way, and is the most dynamic.