Moving data from one tab to other tab automatically
 

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

Moving data from one tab to other tab automatically
 

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

Moving data from one tab to other tab automatically
 

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

Moving data from one tab to other tab automatically
 

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

Moving data from one tab to other tab automatically
 

I've been around for a long time.

Helped a lot of posters and not helped others but have never resorted to
blackmail to get a rating.

To my way of thinking.............this is a new low on these news groups.


Gord Dibben MS Excel MVP

On Thu, 10 Sep 2009 13:41:07 -0700, pshepard
(donotspam) wrote:

Hi Max,

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

Moving data from one tab to other tab automatically
 

Dear Peggy,
Regardless of others commenting, please let me know how this was achieved.
I have said "Yes".
Thanks a lot
max

"pshepard" wrote:

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

Moving data from one tab to other tab automatically
 

Dear Peggy,
Can you please respond as to how u did this, i too have achieved using
pivot tables but not as this, i want it this way as you have done
Thanks
maxim
"max" wrote:

Dear Peggy,
Regardless of others commenting, please let me know how this was achieved.
I have said "Yes".
Thanks a lot
max

"pshepard" wrote:

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