Quote:
Originally Posted by Fuzz
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.
|
From what I know, you can't do this with formulas.
You could just fill down on sheet 2 and hide the sheet if it's for distribution.