What your are asking for is possibly a database. Whether it would be better
to implement this as a database is hard to tell from your description. In
either case essentially what you want to do is to store all of the raw data
in one or more hidden sheets. This data will then be extracted onto other
sheets for reporting purposes while other sheets will be used to add to the
data (for simplicity you may want to add to the raw data directly). If you
keep these functions seperate it will be a lot easier to maintain in the
future.

That is how I would go about it, but that is just my two cents...
--
HTH...

Jim Thomlinson


"cheeser83" wrote:

What I am wanting to do is implement a customer tracking spreadsheet
with with columns labeled things like jobs won, jobs underway, and jobs
finished under one tab of the sheet labeled Worksheet. The other sheet
tabs will be labeled things such as Forecast, Budget, etc....

What I wold like to happen is when the user is in a month such as
January and then goes to the Tools menu and selects another month, such
as the next one, February, the information will transfer from Jan. to
Feb. with the cell assigned to display the month name now saying Feb.
However, I would like to still be able to go back to Jan. in order to
see the info from there.

If anyone has ANY ideas, I would really appreciate it. This one is
stumping me with the flip-flopping of the months!!