Hello,
I have been trying for hours and am unable to find a solution.
Problem: Move row data from multiple tables to 1 table based on the the the cell value in that row.
The data:
Table Name: Mr. Big Stuff
[TABLE="width: 566"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]EMP ID[/TD]
[TD]AGENT[/TD]
[TD]SUPERVISOR[/TD]
[TD]STATUS[/TD]
[TD]ADH[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]86.1[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]Jane Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]86.1[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]89.9[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]Jane Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]91.1[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]93.1[/TD]
[/TR]
</tbody>[/TABLE]
Table Name: Mrs. Boss Lady
[TABLE="width: 566"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]EMP ID[/TD]
[TD]AGENT[/TD]
[TD]SUPERVISOR[/TD]
[TD]STATUS[/TD]
[TD]ADH[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]87.3[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]Jane Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]90.5[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]90.8[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]Jane Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]90.9[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]91.7[/TD]
[/TR]
</tbody>[/TABLE]
If the Cell in ADH is Less than 90.0 I need to move the row to the output table.in the same order as the information. In addition to that i need to add the same data from another table with the same format below the information from the previous table. Like below.
Table Name: Outliers
[TABLE="width: 450"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]EMP ID[/TD]
[TD]AGENT[/TD]
[TD]SUPERVISOR[/TD]
[TD]STATUS[/TD]
[TD]ADH[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]86.1[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]Jane Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]86.1[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]89.9[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]87.3[/TD]
[/TR]
</tbody>[/TABLE]
The information does change but it does not change format. All columns are the labeled the same and do not change. when the data is updated i need it to replace what is there with new data.
I have tried to =Index as well as =vlookup but have been unable to find a successful route of doing this. I am quite new to excel and have been stuck on this for a couple of days. thanks for any help and advice in advance!
I have been trying for hours and am unable to find a solution.
Problem: Move row data from multiple tables to 1 table based on the the the cell value in that row.
The data:
Table Name: Mr. Big Stuff
[TABLE="width: 566"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]EMP ID[/TD]
[TD]AGENT[/TD]
[TD]SUPERVISOR[/TD]
[TD]STATUS[/TD]
[TD]ADH[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]86.1[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]Jane Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]86.1[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]89.9[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]Jane Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]91.1[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]93.1[/TD]
[/TR]
</tbody>[/TABLE]
Table Name: Mrs. Boss Lady
[TABLE="width: 566"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]EMP ID[/TD]
[TD]AGENT[/TD]
[TD]SUPERVISOR[/TD]
[TD]STATUS[/TD]
[TD]ADH[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]87.3[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]Jane Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]90.5[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]90.8[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]Jane Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]90.9[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]91.7[/TD]
[/TR]
</tbody>[/TABLE]
If the Cell in ADH is Less than 90.0 I need to move the row to the output table.in the same order as the information. In addition to that i need to add the same data from another table with the same format below the information from the previous table. Like below.
Table Name: Outliers
[TABLE="width: 450"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]EMP ID[/TD]
[TD]AGENT[/TD]
[TD]SUPERVISOR[/TD]
[TD]STATUS[/TD]
[TD]ADH[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]86.1[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]Jane Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]86.1[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mr. Big Stuff[/TD]
[TD]Billing[/TD]
[TD]89.9[/TD]
[/TR]
[TR]
[TD]00000000[/TD]
[TD]John Doe[/TD]
[TD]Mrs. Boss Lady[/TD]
[TD]Billing[/TD]
[TD]87.3[/TD]
[/TR]
</tbody>[/TABLE]
The information does change but it does not change format. All columns are the labeled the same and do not change. when the data is updated i need it to replace what is there with new data.
I have tried to =Index as well as =vlookup but have been unable to find a successful route of doing this. I am quite new to excel and have been stuck on this for a couple of days. thanks for any help and advice in advance!
