LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 65
Default Macro Required....

Hi All,
I have a report as follows

Site Case ID+ Priority* Arrival Time Response Time Status* Case Type*
Pakistan AAHD00000376417 Medium 01/01/2009 12:45 01/01/2009
12:48 Closed Incident
Malaysia AAHD00000376584 Medium 02/01/2009 9:29 02/01/2009
9:32 WIP Incident
Indonesia AAHD00000376695 Low 02/01/2009 13:21 02/01/2009
14:08 Closed Request
India AAHD00000377262 Medium 05/01/2009 10:00 05/01/2009
10:03 Resolved Incident
Korea AAHD00000377363 Medium 05/01/2009 11:32 05/01/2009
12:19 Closed Question
India AAHD00000377630 Medium 05/01/2009 15:19 05/01/2009
15:20 Closed Incident
India AAHD00000377669 Medium 05/01/2009 16:34 05/01/2009
16:35 Resolved Incident
China AAHD00000377681 Medium 05/01/2009 17:25 05/01/2009
17:26 Closed Question
China AAHD00000378016 Medium 06/01/2009 9:54 06/01/2009
9:58 Closed Incident
Philippines AAHD00000378024 Medium 06/01/2009 10:01 06/01/2009
10:01 Closed Incident
Thailand AAHD00000378058 Medium 06/01/2009 10:30 06/01/2009
10:31 WIP Incident

I want country wise output in diffrent sheets
Out put should look as follows:-
Site CaseType Priority Status CaseID
India Incident Medium Closed AAHD00000377630
India Incident Medium Resolved AAHD00000377669

like wise I want in all the sheets for each country wise.

TIA
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro required please Dr Hackenbush Excel Discussion (Misc queries) 4 February 10th 10 09:29 AM
Macro Help Required Dan Wood Excel Discussion (Misc queries) 3 January 5th 10 05:49 PM
macro required.. [email protected] Excel Programming 1 December 15th 08 07:30 PM
Pilgrim needs help: Effecting keystroks required by a macro nested within a macro. [email protected] Excel Programming 1 May 14th 05 03:46 AM
Macro help required! Don Niall Excel Programming 7 June 24th 04 07:12 PM


All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"