Hi Max,

If you click yes on this post as being helpful - I will post how I did this.

--
If this post helps click Yes
---------------
Peggy Shepard


"max" wrote:

Dear Peggy,
Thanks a lot for your help. I liked it but how do we actually do this, i
wanted to know and where are my other tabs , i am a bit confused how u
achieved this want to learn
Thanks
max

"pshepard" wrote:

Hi Max,

http://www.4shared.com/file/13157857...8/Report2.html

Using a combination of consolidated pivot tables.
--
If this post helps click Yes
---------------
Peggy Shepard


"max" wrote:

Hi,
Please find the sheet on this site.
http://www.4shared.com/file/13154684...25/Report.html


In "WeeklyReport" tab we have the SMOid column(C)
If you observe one SMO id will be shared among different groups
for ex: 2080 if you select you can find 2 rows.
in another instance one group can use the same smoid for diff tasks
for ex if you filter for 2613 billing uses it for 2 and others too use it.
My question is taht based on these SMOids i want to move this data to
another tab called "based on SMOid"
The way i want i have shown s sample in that sheet.
How can i achieve this to appear automatically, if you can help me please.
I need basically all the data to be managed this way for all smoids
regardless of smoid has one productline or many.

Other than my idea if there is any other way of achieving please do let me
know thru existing features in excel.

Also the projects with Smo id 0000 should be appearing last in the list as
there are more number of projects
Thanks a lot for your time
max