To get data from one sheet to other and perform some calculations

[Chuck123]

Hi All,

I had data in a sheet in the order of countries.Each country has data in fixed number of rows(Say 20 rows per country).I am trying to take data country wise from the sheet 1 and insert few rows for each country and fill those rows with calculated values.

I have attached the sample data.Sheet name 'data' contains my original data.Sheetname 'Solution' has the model of how the solution is going to be.

Please help to achieve this.

Thanks to everyone in advance for your valuable time and efforts.

Best Regards,
Chuck123

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...60#post3312160

Thread Closed.