A simple "if" would be enough if you have only 2 columns:
=IF($A$1="May",A10,B10)
and drag down to copy. This is assuming that your may data is in range
A10 and below. And June in B10 and below.

For more than 2 columns, you could use HLOOKUP

Now the formula I use to show the data from the bottom to the table at
the top is SUMIF but when the data gets sent from the userform it shows
it at the top as 0 even though the number is say 10 at the bottom.

Did not understand what you want here. Could you give an example.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=376249