Calculating cells between separate MS Excel files?

Quote:

---

Originally Posted by MickG

Thanks for the help guys....now to spend the next 2 weeks modifying all my spreadsheets for the next fin year:(:D:D

Aye, Mick

---

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

Quote:

---

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 :eek::D

---

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

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

Quote:

---

Originally Posted by sschmez

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

---

Would appear not......do explain though:D

Quote:

---

Originally Posted by MickG

Would appear not......do explain though:D

---

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):D

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

Just to add a bit more confusion to this, you can also "paste special" which will give you another set of headaches, err sorry, that should be options.;)

Say you want to take all of the data from one spreadsheet, and paste it into another without all of the formulas, then use "values". This will give you the data, but will not update. Useful when sending files to senior management that don't really know what they are doing.:mad:

Should you wish to use the same formulas in another spreadsheet, then use "formulas". Then save the new file under a different name.