Excel question...

[Justin7]

Assume I have MLB data organized by team... I.e. lines 101-200 are one team, 201-300 are the next, ...

Is there an easy way to feed this data into a formula? So at the top, I would enter "1" and "2" to draw data from lines 101-200 and 201-300m and apply it in a formula (i.e. expected runs)?

[Ganchrow]

Assume I have MLB data organized by team... I.e. lines 101-200 are one team, 201-300 are the next, ...

Is there an easy way to feed this data into a formula? So at the top, I would enter "1" and "2" to draw data from lines 101-200 and 201-300m and apply it in a formula (i.e. expected runs)?

Just use named ranges and feed them in to VBA functions.

[reno cool]

"That's all right" said the priest, "I wanted to know about Freight too."

[Wrecktangle]

Not sure exactly what the Q is, but Excel is so powerful these days, you can do this and almost everything even without VBA...just runs (far) slower than compiled.

...far cry from the original Visicalc...

...Oh yeah, nobody here knows what that is. But I bet Ganchrow does since he usta play Choplifter on a VIC-20...or was that a PET?