I don't think that is what I am looking for. I don't want a corresponding row on sheet 2 for every row in sheet 1, I just want one row that has the formula, and every row on sheet one gets put through that.
If anyone is a programmer, it's just a basic function passing a variable. I could do it in VBS, but I don't want a macro in this, as it will be distributed.
|