Hi bob,
It is working perfectly, but i wanted some more help. which
is very crucial for to complete the work. The rates shown in the table
is the standard rate, it may change or i have to give some better rates
to the customer sometimes. so there is a discount limit of both ways
plus and minus. I can say as tolerance limit. now the table is as
follows
CURRENCY / PURCHASE/ SALE/ TOLERANCE LIMIT
USD ---- 384 ----- 386 ------------------2
GBP ------ 685------- 700-----------------3
EUR----------- 480-------490--------------5
INR-----------8 ----------9-----------------0.5
THB----------9 ----------10----------------0.3
AED-------104-----------105--------------0.3
SAR-------102-----------103-------------0.5

The problem is i have given the formula in cell E, if i started change
the rate or anything on E will erase the formula . Instead my mind is
going in the other way create a duplicate row in sheet 2 itself (like
the one in sheet 1) and call back .
what is your opinion? Is there any other way? I know you can help me ,
b coz you sorted so many problems earlier too. Others also welcome.
thanks in advance
with regards
NOWFAL


--
nowfal
------------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=399926