Hi,
I've created a Combo Box inside a sheet based on data from another sheet.
When an item is selected in this list I would like excel to fill a couple
cells with the data that is correlated to this item from the other sheet.
I've been trying for days now. Reading macro tutorials and such. And just
can't figure out quite how to do what I want. Is there anything anyone
recommends reading?
Or, I've hit a number of different road blocks. But one in particular is:
I've got a cell with a number corresponding to the row of data I want on the
other sheet, but I don't know how tell excel something like
= Data!A(Main!B24) where the row is sort of variable.
Sorry for all this babble, but any help would be appreciated.

PS: I started initially with just a data validation list that I could go
back to if that would make it easier.