B
beaches045
Own a pet store, Use Excel XP, maintain a Daily Sales report which is set up:
By Month, then by Day Of course - all department numbers are entered in a
column, the sales figures are posted, sub totaled at the bottom, discounts
deducted, sales tax figured, balanced against cash register tape, actual cash
count, credit card count, itemized check count.
Totals are carried down and across for the cumulative month total.
This workbook is linked to a similar one for years 2000, 2001, 2002, 2003
and now 2004.
Lastly there is a recap sheet at the end - carrying forward each month's
final numbers by department.
OK, This has gone on for three years now. At some point can it ever end?
Can a set of numbers from a previous workbook which will not change be
"locked" in? So I can carry forward those "locked in" numbers to future
years? Rather than always needing to keep all of the previous years there in
the same place...
It is quite difficult to keep all of the previous years together and in the
same place.
It seems as though there is a greater chance for something being lost,
corrupted.
All in all it is just a very time consuming process setting up a new year.
Which is where I am now.
Wondered if someone out there who obviously knew how to properly and
efficiently use Excel could and would shed some light.
Thank you.
By Month, then by Day Of course - all department numbers are entered in a
column, the sales figures are posted, sub totaled at the bottom, discounts
deducted, sales tax figured, balanced against cash register tape, actual cash
count, credit card count, itemized check count.
Totals are carried down and across for the cumulative month total.
This workbook is linked to a similar one for years 2000, 2001, 2002, 2003
and now 2004.
Lastly there is a recap sheet at the end - carrying forward each month's
final numbers by department.
OK, This has gone on for three years now. At some point can it ever end?
Can a set of numbers from a previous workbook which will not change be
"locked" in? So I can carry forward those "locked in" numbers to future
years? Rather than always needing to keep all of the previous years there in
the same place...
It is quite difficult to keep all of the previous years together and in the
same place.
It seems as though there is a greater chance for something being lost,
corrupted.
All in all it is just a very time consuming process setting up a new year.
Which is where I am now.
Wondered if someone out there who obviously knew how to properly and
efficiently use Excel could and would shed some light.
Thank you.