I have a function that runs through data and breaks up, sums, and groups different information (big thanks to Hans for helping me out with it).

Now i would like to make it more user friendly. Before i had the column numbers hard coded into the formula, but now people in the office are starting to use the function for different data sets where the columns are different. I created a simple form were people can enter the number of the column.
row start = 2
group by col = 5
sum value of col = 11

the problem is that people have a hard time figuring out that column K is 11, and would much rather type in K into the form then 11.

is there a quick and easy way (or possibly a built in function in excel) that i can do this.
I realize i could build a giant Select Case statement, but i just think there has to be a better way.

Another quick question: is there a way to create an input rule in excel forms similar to Access, where i can limit what a user inputs, for instance, the row text box can only be numbers, and the column can only be letters.

thanks