GilJay, eat cold steel or Target is there any way to...?

[+DOC+]

Target, when clicking on some of the columns in those Excel files, such as column V (unit stats) in the unit Excel file for instance, they often refer to:

"='Linked To'!$B7"

Is there any way to simply modify the stats without these columns/rows referring to links in other files!?

Cheers




------------------
=MizuDoc Otomo=

[JRock]

Actually that's a link to another cell in that same file. In your example, cell B7.

[+DOC+]

B must refer to column B then, and that simply states the unit type... infantry, cavalry, etc!?

I actually think it refers to another sheet personally.



[This message has been edited by +DOC+ (edited 09-07-2002).]

[+DOC+]

. double post



[This message has been edited by +DOC+ (edited 09-07-2002).]

[JRock]

Quote Originally posted by +DOC+:
B must refer to column B then

Yes, cell B7 is the cell in column B, row 7.


I actually think it refers to another sheet personally.

That could be - I'm not an Excel expert, but I know that a link to $B7 is a link to cell B7.
[/QUOTE]

[+DOC+]

actually, excuse my ignorance Target, forget my last post!

bottom left hand corner... one can move between several sheets all of which are cunnilingously linked together.

excellent, this is a modder's heaven!

[+DOC+]

Having said that though Meister Target, it is rather confusing knowing what to do, which one of the many sheets should/can be edited. Most of them have links to other sheets and so it's difficult to determine the right sheet to edit.

For example modifing the costs of units or the unit stats?! How are these done in the huge Excel sheets?

[This message has been edited by +DOC+ (edited 09-07-2002).]