"easygoer714" wrote:

how do i create formulas that follow a name on a different sheet. I want it
to find a name in a list on a seperate worksheet and perform the calculations
using values in set columns in the record. I also want these calculations to follow their set record even if that record moves. Also, the value i want it to look up in the seperate datasheet is in the datasheet i want the formulas in.