[edslunch]

Originally Posted by Fuzz

Basically, I'd like to pass a cell value like you would pass a variable to a function, and get a result in another cell.

I've got what will be an expanding table, and there will be a number in Column A. I'd Like column B to get the result of a complicated process on another sheet. I know I could put it all on one sheet, and fill down, but I'd have about 20 extra columns that I'd rather keep off the main sheet. So is there a way to pass that to the other sheet, run it through one row of calculations and spit it back out in column B?

Replied