Hello, all.

I am looking to do two things to an Excel spreadsheet:

The first thing I'd like to do is to program my worksheet to pull and display complete rows of information from another worksheet if column C matches a certain codeword. There will be about 200 instances of this codeword in column C in a sheet of about 1000 rows. How do I program Excel to pull all of those 200 instances and not just the first one?

The second thing I'd like to do (and I know it's a pretty basic task for Excel, but I don't know where to look for a tutorial on it, since I don't know what it's called) is to have my first task pulling information from another spreadsheet on the Network, and to automatically update that information when I open the file. I don't even know what this is called, so I'm having a hard time finding info on how to get it done.

Help is greatly appreciated on either topic!

-Laura