Macro help urgent urgent
 

Put all your data in one worksheet.
Use column A for the country. Column B for Qwest, C for MCI, etc.

Add one header row (row 1)

select your range
Then Data|Pivottable.
follow the wizard to the dialog with Layout on it.
drag the Country icon to the Row field
Drag Quest to the Data field, MCI to data, etc
If any of them don't say Sum, then double click on them and change it to "sum
of"

click ok/finish.
Drag the Data button one column (same row) to its right.

Is that close?

chandra wrote:

I get every day dail list showing country name, minutes
used as per provider wise(mci,qwest etc etc). Some times
we may get new country names besides already existing. I
need to prepare a weekly report ( like country name,
minutes used, carrier ).

Qwest daily report:
colum A colum B
Germany 2340
France 4500
Italy 90

MCI daily report:
colum A colum B
Germany 1000
France 600
USA 5000
Canada 300

I want a consolidated report like this

Colum A colum b colum C
country carrier(qwest) carrier(mci)
Germany 2340 1000
France 4500 600
Italy 90 -
USA - 5000
Canada - 300

any suggestion pleaese

--

Dave Peterson