Thread: Calculating cells between separate MS Excel files?

Originally Posted by FenianEel

Mick,

In a previous life, I also taught Excel among other things. Pretty sure I still have the discs and workbooks, (basic though to advanced), If I can find them I'll get them to you. Still used to get updated course material sent to me, I think the last ones I received were only about 18 mths ago.
Now to find them

Mate, you're a scholar and a gentleman Been meaning to call you as well as I haven't heard from you in a while...will try you now

Cheers for the offer and there's a Guinness or two in it for you if you find them

Originally Posted by sschmez

You haven't discovered Find/Replace then ????? ......

Would appear not......do explain though

Originally Posted by MickG

Would appear not......do explain though

Excellent little feature to be found in the "Edit" menu dropdown.

Backup your file first - don't ask how I know
Then tell it to find "07-08" or whatever you need changed and then tell it to replace that with "08-09" or whatever you want it to be. Use it to change formulae only or every instance of "07-08" (eg. incl headings).

When Ms Smith from the sales team becomes Mrs Jones change over very quickly and easily (and again when she gets back from her honeymoon and she's actually Mrs Johnes)

When spreadsheets are linked as described earlier and changes are made to the source (Column added) so that now the data you need is in cell G7 instead of cell F7, find/replace (not necessary if both files are open when changes are made - excel adjusts it automatically)

Stevo