Moving data from one tab to other tab automatically

  • Thread starter Thread starter max
  • Start date Start date
M

max

Hi,
Please find the sheet on this site.
http://www.4shared.com/file/131546848/fe4cc25/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
 
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
 
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
 
Dear Peggy,
Regardless of others commenting, please let me know how this was achieved.
I have said "Yes".
Thanks a lot
max
 
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
 
Back
Top