Hi. I am quite new at VBA programming and would like some help.


I have a raw datasheet and i wished to do a program to get an output
into another worksheet of the same workbook using an input/msg box to
allow users type in the 5 different fields.
eg.
Apple
Orange
Pear
Banana
Mango

I hope somebody could help me with this.

Previously i have this

Sub GetRange()
Dim Rng As Range
On Error Resume Next
Set Rng = Application.InputBox(prompt:="Enter range", Type:=8)
If Rng Is Nothing Then
MsgBox "Operation Cancelled"
Else
Rng.Select
End If

which help me to getRange from my worksheet. However, I wish to have an
imput box that allows the user to enter, e.g ENTER A FRUIT. And If i
type Banana. The whole row which contains Banana should be paste into
another worksheet. Is it possible?

Another question i have is, i hope to sum up some counts for different
specifications. I noe using =sum() function could help. However, i
would like to do a simple VBA program so that it will automatically
update the sum for me in future when i have an update in various
specifications. How can i do it? I hope somebody could help me with
this too..

Thanks!


--
ryll
------------------------------------------------------------------------
ryll's Profile: http://www.excelforum.com/member.php...o&userid=28605
View this thread: http://www.excelforum.com/showthread...hreadid=483030