Hi Bala,
Do follow the below steps and post back, if you still face any issues.
1. Open WB > Show > Maximize
2. Get your Data in Collection using inbuilt utility MS Excel VBO
3. Create new worksheets for each currency, say Worksheet1_INR , Worksheet2_USD
4. Filter your collection on the basis of currency as (you can replace INR with your input current codes):
"[Currency] LIKE '*INR*'"
Store the result in new collection
5. Before pasting the new collection in Worksheet, better to check if that contains any rows or not.
6. Activate the Worksheet and paste the new collection there.
You can perform the same steps for rest of the currency codes.
Thanks.