cwolfe8229
New Member
- Joined
- May 29, 2007
- Messages
- 29
Is it possible to copy lines of data into a new tab based on the contents of the data? In other words, I have a large dataset (updated twice daily) and I want to create tabs such that only lines of data with condition A are copied into the new tab (where I then have a pivot table do analysis on that data). And in a different tab I only want data with condition B, and I have another pivot table to do analysis there.
For example:
[TABLE="width: 384"]
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"]A[/TD]
[TD="class: xl63, width: 64, align: center"]B[/TD]
[TD="class: xl63, width: 64, align: center"]C[/TD]
[TD="class: xl63, width: 64, align: center"]D[/TD]
[TD="class: xl63, width: 64, align: center"]E[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="class: xl64, align: center"]Plant[/TD]
[TD="class: xl64, align: center"]Color[/TD]
[TD="class: xl64, align: center"]Lang.[/TD]
[TD="class: xl64, align: center"]Unit[/TD]
[TD="class: xl64, align: center"]Qty[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="class: xl65, align: center"]5060[/TD]
[TD="class: xl65, align: center"]Silver[/TD]
[TD="class: xl65, align: center"]EN[/TD]
[TD="class: xl65, align: center"]113[/TD]
[TD="class: xl65, align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="class: xl65, align: center"]9920[/TD]
[TD="class: xl65, align: center"]Black[/TD]
[TD="class: xl65, align: center"]EN[/TD]
[TD="class: xl65, align: center"]119[/TD]
[TD="class: xl65, align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="class: xl65, align: center"]9920[/TD]
[TD="class: xl65, align: center"]Black[/TD]
[TD="class: xl65, align: center"]SP[/TD]
[TD="class: xl65, align: center"]101[/TD]
[TD="class: xl65, align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="class: xl65, align: center"]5060[/TD]
[TD="class: xl65, align: center"]Silver[/TD]
[TD="class: xl65, align: center"]SP[/TD]
[TD="class: xl65, align: center"]113[/TD]
[TD="class: xl65, align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="class: xl65, align: center"]9920[/TD]
[TD="class: xl65, align: center"]Silver[/TD]
[TD="class: xl65, align: center"]EN[/TD]
[TD="class: xl65, align: center"]101[/TD]
[TD="class: xl65, align: center"]1[/TD]
[/TR]
</tbody>[/TABLE]
I want a tab with only Plant 9920 data and another tab with only Silver data and I'll have pivot tables for each summing qty based on the unit type.
Thanks
For example:
[TABLE="width: 384"]
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"]A[/TD]
[TD="class: xl63, width: 64, align: center"]B[/TD]
[TD="class: xl63, width: 64, align: center"]C[/TD]
[TD="class: xl63, width: 64, align: center"]D[/TD]
[TD="class: xl63, width: 64, align: center"]E[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="class: xl64, align: center"]Plant[/TD]
[TD="class: xl64, align: center"]Color[/TD]
[TD="class: xl64, align: center"]Lang.[/TD]
[TD="class: xl64, align: center"]Unit[/TD]
[TD="class: xl64, align: center"]Qty[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="class: xl65, align: center"]5060[/TD]
[TD="class: xl65, align: center"]Silver[/TD]
[TD="class: xl65, align: center"]EN[/TD]
[TD="class: xl65, align: center"]113[/TD]
[TD="class: xl65, align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="class: xl65, align: center"]9920[/TD]
[TD="class: xl65, align: center"]Black[/TD]
[TD="class: xl65, align: center"]EN[/TD]
[TD="class: xl65, align: center"]119[/TD]
[TD="class: xl65, align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="class: xl65, align: center"]9920[/TD]
[TD="class: xl65, align: center"]Black[/TD]
[TD="class: xl65, align: center"]SP[/TD]
[TD="class: xl65, align: center"]101[/TD]
[TD="class: xl65, align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="class: xl65, align: center"]5060[/TD]
[TD="class: xl65, align: center"]Silver[/TD]
[TD="class: xl65, align: center"]SP[/TD]
[TD="class: xl65, align: center"]113[/TD]
[TD="class: xl65, align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="class: xl65, align: center"]9920[/TD]
[TD="class: xl65, align: center"]Silver[/TD]
[TD="class: xl65, align: center"]EN[/TD]
[TD="class: xl65, align: center"]101[/TD]
[TD="class: xl65, align: center"]1[/TD]
[/TR]
</tbody>[/TABLE]
I want a tab with only Plant 9920 data and another tab with only Silver data and I'll have pivot tables for each summing qty based on the unit type.
Thanks