Excel formulas

[jody]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Alright, I don't know what I'm doing and I'm likely using the wrong terms but here we go:

I have locked Excel invoice and would like to add a "materials used" section to this invoice. In this section I would like to create a formula, linked to another Excel doc., listing all materials etc. and be able to type in the material and it would auto fill with the material information...?

Any help would be much appreciated.

 

[CyberTaz]

Well, if the sheet is "locked" the first thing you need to do is turn the
Protection OFF in Tools> Protection> Unprotect Sheet. However, the
Protection may be password protected, so if you don't have the password any
further suggestions won't do you much good Once the Protection is off
you can make any changes you wish, & what you describe should be possible.
See if you can turn protection off first.