Problem with spreadsheet

[Fitty]

First and foremost, I'd like to thank the admins of this forum fo
providing a place to discuss excel. It's a great forum !!

I do have a problem however. I am in the midst of creating an
excel spreadsheet that will have 52 pages (1 page/week)
Now there will be several columns and rows with weekly statistics
and year to date statistics. What I need to do is learn how to creat
52 separate pages within this worksheet (let's say for argument sake
name each page the date..i.e -Jan 04.....Jan 11...etc) and have eac
page populate the previous week's year to date values when I add th
current week's values.

I hope I have explained this properly..!!
I will attach a sample sheet so you see what I mean.

Thanks again for a great forum.
Any help is greatly appreciated

Attachment filename: temp sales sheet.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50339

 

[Earl Kiosterud]

Fitty,

Your attachment was probably stripped. Attachments aren't allowed in these
newsgroups.

First of all, try to get all your data into one sheet, especially if you'll
be doing any summarizing. Use a column to differentiate weeks, if
necessary, or just use a date column. There are all kinds of summarizing
tools (Pivot tables, Database functions, Subtotals) that don't work with
data spread across sheets. Even if you're not going to need summary data,
this may work out better for you. An autofilter can reduce the sheet to the
date(s) or week you're interested (possibly with a helper column). You
could use that if you needed to print weekly (or daily, or whatever). You
may not need the carry-forward you asked about, or if you do, it will now be
accomplished via a formula on the sheet.

If you must have separate sheets (mark my words! ), you can use a formula
in a sheet to pick up any data from another sheet. You'll have to
separately build 51 of them, each referring to the prior week by name, or
use a special function to get the physically prior sheet with a generic one.
Post back for instructions on that. It's "linking to another sheet."

Carefully consider using one sheet. It will require a re-think of your
strategy, but you'll almost certainly be glad you did.