Moving data from one tab to other tab automatically

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
 
M

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
 
P

pshepard

Hi Max,

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

Gord Dibben

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
 
M

max

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copyin the greater than 15 days project rows from one sheet to ano 3
Main sheet automatically picks up data from other sheets 14
Pull data from different worksheets/tab into one Pivot Table 3
Data from one tab to another 1
Automatically moving from one cell to another 3
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Automatically copy data from one worksheet to another 2
item # in one sheet want to pull data that matches from other tab 3

Top