Excel Slow performance

[Paul_Hossler]

Note; I do accept that my opinion is totally biased since I have been using computers for 49 years, in more languages than I could possibly count.

@offthelip --

And my opinion isn't????

I mended punch paper tapes with scotch tape to feed them into the reader

Then they came out with the new fangled 'key-to-disc' technology that eliminated having to punch cards and worry about dropping the box in the hallway



@SamT --

po-ta-to, po-tah-o

Yes, you and snb are perfectly correct -- you and snb and I could figure it out. Maybe the OP could also

If I were doing it for myself, I would have done it differently: Consts or eNums, an array (possibly) for the row, intelligent determination of what new data requires filling in, etc.

The examples and suggestions all seem to recompute data that has be computed.

My approach allows the selection of data to be computed. Yes, I'm sure that logic could be added to build the data array with only data that needs to be computed and logic to build the requested Roster sheet


Bottom Line:

I agree that we disagree