Thank you for ur reply but that didn't work with me.
Anyhow, In my main file I have four columns A B C and D in column A
have the custumer names I column B I have the Price In column C
have the romm number and in column D I have a special code for ever
custumer What I want is when I type any number greater than 0 in an
cell in column D an inputbox appears to enter a room number availabl
in column C and when I press OK it takes me to the custumer name fo
the room number I type in the inputbox and when the room number i
not available in column C it give me a msgbox tells that the numbe
is not available.
The code I deliverd is doing this job but it is soooo log for me
I want a short one please.
I hope that my question is clear now
--
LoveCandl
-----------------------------------------------------------------------
LoveCandle's Profile:
http://www.excelforum.com/member.php...fo&userid=2861
View this thread:
http://www.excelforum.com/showthread.php?threadid=48304