linking sheets

Mar 1st, 2002, 11:08 AM

sheet 1 has the 7 days of wk. sheet 2 has the whole month.how do i keep the totals from the previous wk intact when i start to work on new wk.

Corni · Mar 24th, 2002, 09:53 AM

Do you really need to link Sheet1 and Sheet2. Is a little bit of a temptation to link or automate, but try to reason if there is any advantage for this. In your particular case, why not copy and paste from sheet1 to sheet2 in the relevant cells.
I would use formulas if were for ex. twelve months in twelve sheets, and would like to input in a weekly template data that should be then placed in the right month and the relevant dates. In this case you need to have two cells on top of the weekly table with the start date and the end date of the week.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 11:08 AM	#1
Guest Posts: n/a	sheet 1 has the 7 days of wk. sheet 2 has the whole month.how do i keep the totals from the previous wk intact when i start to work on new wk.

Mar 24th, 2002, 09:53 AM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	Do you really need to link Sheet1 and Sheet2. Is a little bit of a temptation to link or automate, but try to reason if there is any advantage for this. In your particular case, why not copy and paste from sheet1 to sheet2 in the relevant cells. I would use formulas if were for ex. twelve months in twelve sheets, and would like to input in a weekly template data that should be then placed in the right month and the relevant dates. In this case you need to have two cells on top of the weekly table with the start date and the end date of the week.