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


--
trav
------------------------------------------------------------------------
trav's Profile: http://www.excelforum.com/member.php...o&userid=31420
View this thread: http://www.excelforum.com/showthread...hreadid=514461