help with vlookup or index or match or what?

[rcirone]

I have 4 taps
1. Two-Ten tab
2. Loc tab
3. Purple Tap
4. Data Dump Tab
I am try get the info from data dump tab to all the other taps with the right Program. if you look at the pic you will see what I need to do please help I do not know if I use vlookup index or what?
Sorry but I can not change the order of the data dunp Tab.
Please Help?

 

[Drrellik]

there are always several way to accomplish the end result and I have found sometimes I am not familiar or comfortable trying something new, especially if I dont understand how it works. So even though you have several answers I will offer this.

since you only have 4 tabs and I am hoping a limited number of employees. in each tab insert a column in the very front. Column A and number the rows 1,2,3,4 if you know how double click and autofill. (you will delete this later)

Now on the home tab under sort & filter do a custom sort and use the program column and add a level and use the agent name. for all four tabs.

you should be able to then from your dump tab select the data for the others tabs in large blocks and do a Paste special - Paste Link.

After you have all the dump data linked to your three other tabs. go back and do a custom sort based on Column A to put your data back in the original position.

Protect and lock if you want your sub tabs and as you populate the dump sheet it will populate the others.
(this is of course provided your dump sheet does not change very often and the employees dont change often either.) not the best way just anotherway.

Don

 

[a11jks]

Yeah, you can easily setup a macro to do the custom sorts and hide other programs. That way all you have to do is click the button that represents which program.

If that is something you would be interested, I can give you example code on a project i did something similar.

 

[rcirone]

I have 4 taps
1. Two-Ten tab
2. Loc tab
3. Purple Tap
4. Data Dump Tab
I am try get the info from data dump tab to all the other taps with the right Program. if you look at the pic you will see what I need to do please help I do not know if I use vlookup index or what?
Sorry but I can not change the order of the data dunp Tab.
Please Help?

Here is some info that may help.
Here are the feilds I have in each of the tabs. They go across from A6:T6 and go down 99 rows

Agent Name
Emp#
Supervisor Name
Program
Phone
True Phone
Total Logged
Productive Idle
Lunch
Non-Productive
Talk
Calls
Calls/Hr
CWT Minutes
Cust Cont Time
CCT %
AE Utilization
AE Productivity

Here are the names of all the tabs
BSP
Leads
WWS
WWS FRT
LOC
CTA
Cananda
Special Projects
Purple

Here are the fields on the Data Dump Tab
Agent Names
Emp#
Supervisor Name
Program
Phone
True Phone
Total Logged
Productive Idle
Lunch
Non-Productive
Talk
Calls
Call/Hr
CWT Minutes
Cust Cont Time
CCT%
AE Utilization
AE productivity

 

[Aladin Akyurek]

Here is some info that may help.
Here are the feilds I have in each of the tabs. They go across from A6:T6 and go down 99 rows

Agent Name
Emp#
Supervisor Name
Program
Phone
True Phone
Total Logged
Productive Idle
Lunch
Non-Productive
Talk
Calls
Calls/Hr
CWT Minutes
Cust Cont Time
CCT %
AE Utilization
AE Productivity

Here are the names of all the tabs
BSP
Leads
WWS
WWS FRT
LOC
CTA
Cananda
Special Projects
Purple

Here are the fields on the Data Dump Tab
Agent Names
Emp#
Supervisor Name
Program
Phone
True Phone
Total Logged
Productive Idle
Lunch
Non-Productive
Talk
Calls
Call/Hr
CWT Minutes
Cust Cont Time
CCT%
AE Utilization
AE productivity

Did you try post #10?

 

[rcirone]

I try #10 and this is what I get (0)

Sorry this is the right one

=IFERROR(SMALL(IF('Data Dump tab'!$D$2:$D$501="Two-Ten",ROW('Data Dump tab'!$D$2:$D$501)-ROW('Data Dump tab'!$D$2)+1),ROWS($A$2:A2)),"")

 

[Aladin Akyurek]

I try #10 and this is what I get (0)

=IFERROR(SMALL(IF('Data Dump tab'!$A$2:$A$501="Two-Ten",
ROW('Data Dump tab'!$A$2:$A$501)-ROW('Data Dump tab'!$A$2)+1),
ROWS($A$2:A2)),"")

You need to confirm this fomula with control+shift+enter, not just enter. That is, press down the control and the shift keys at the same time while you hit the entire key.

 

[rcirone]

now I do not get anything ctrl shift enter

 

[Aladin Akyurek]

now I do not get anything ctrl shift enter

What do you mean? Are you on a Mac?

 

[markmzz]

Hi Rcirone,

Look at your PM box.

Markmzz

 

[Aladin Akyurek]

I try #10 and this is what I get (0)

Sorry this is the right one

=IFERROR(SMALL(IF('Data Dump tab'!$D$2:$D$501="Two-Ten",ROW('Data Dump tab'!$D$2:$D$501)-ROW('Data Dump tab'!$D$2)+1),ROWS($A$2:A2)),"")

Right. Programs are in column D on Data Dump.

You need to apply control+shift+enter to this formula which you place in A2 on the Two-Ten sheet. See the original reply for the rest of instructions.