copying and pasting data in separate sheet

**ashwin_bist** · 11-05-2008, 08:54 AM

hi All,

I need help again....

I get the file for the sales report from North America region. I need to put all the different region in separate sheet and analyse

Ex- Canada, USA and Lat America, all need to be divided in to their own sheet and the analyse them.....

Is there any macro which can do that.

Regards
Ashwin

**royUK** · 11-05-2008, 09:05 AM

Depends on the layout of the data. The obvious solution would be a PivotTable.

I have posted code that you could adapt here

http://www.excelforum.com/excel-prog...n-keyword.html

**davesexcel** · 11-05-2008, 09:08 AM

There is a macro that can do that. It needs to be written to suite your workbook.

How is your workbook laid out?

**ashwin_bist** · 11-05-2008, 09:13 AM

I am attaching the file for your referance.

The pivot table wont work for me as i need to give the data to different manager and they dont want their data shown to other managers.