I have a rate table Rate Machanism in Sheet 1, and Country with Fees in Sheet2 I, Fax cover in Sheet3.

1) to automate the calculation - if you calculate for one country then it feeds on the FAX cover sheet.

(2) if there are multiple requests, then it should put it in the next line.


(3) if there are requests from several countries, it should be able to distinguish it and also put in the fax sheet.


My knowledge in this area is much exhausted really,

Can someone help?


Thanks