Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
URGENT: Please help with tab-order macro | Excel Discussion (Misc queries) | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
MACRO URGENT HELP | Excel Discussion (Misc queries) | |||
Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) | |||
Urgent - Help VBA Macro | Excel Discussion (Misc queries) |