Can the linking ever end?

[Guest]

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.

 

[Harald Staff]

Hi

If I understand this right, you have a cell range with formulas, probably
like
='C:\my path\[filename.xls]Sheet100'!$C$4

Select this range. Copy.
Choose menu Edit > Paste special > select Values > OK. Now the formulas in
the selected cells are replaced with their static numeric values.

HTH. Best wishes Harald

 

[Guest]

Oh Harald,

I feel so...well after the post I wrote I am SURE I need not expand!

Thank you so very much...I KNEW it had to be easy - but I just could not get
there!!

Now I can start on all the 2005 sheets!!

Susan

Hi

If I understand this right, you have a cell range with formulas, probably
like
='C:\my path\[filename.xls]Sheet100'!$C$4

Select this range. Copy.
Choose menu Edit > Paste special > select Values > OK. Now the formulas in
the selected cells are replaced with their static numeric values.

HTH. Best wishes Harald

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.

 

[Harald Staff]

Good luck Susan. Thanks for the feedback.

Best wishes Harald