Pull data from one sheet to others

[nits1982]

I wanna pull data from master sheet to other sheet like i want testing rework to go to testing rework only date wise.

Thanks in Advance

[TABLE="width: 868"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Month[/TD]
[TD]Where NC Identified[/TD]
[TD] [/TD]
[TD]Concern[/TD]
[TD]NC Details[/TD]
[TD]Qty.[/TD]
[TD]Remark[/TD]
[/TR]
[TR]
[TD]9 January 2013[/TD]
[TD]Jan[/TD]
[TD]Testing[/TD]
[TD]AssemblyRework[/TD]
[TD]Assembly[/TD]
[TD]Water pump mounting bolt observed loose.[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]30 January 2013[/TD]
[TD]Jan[/TD]
[TD]Assembly[/TD]
[TD]AssemblyRework[/TD]
[TD]Assembly[/TD]
[TD]Abnormal noise from gear end side(Outer gear position wrong).[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]12 January 2013[/TD]
[TD]Jan[/TD]
[TD]Testing[/TD]
[TD]TestingReject[/TD]
[TD]Testing[/TD]
[TD]Lub oil leak from cylinder head no.3(R. Cover joint)[/TD]
[TD]1[/TD]
[TD]Reject[/TD]
[/TR]
[TR]
[TD]14 January 2013[/TD]
[TD]Jan[/TD]
[TD]Testing[/TD]
[TD]TestingReject[/TD]
[TD]Testing[/TD]
[TD]Lub oil leak from oil filling body joint.[/TD]
[TD]1[/TD]
[TD]Reject[/TD]
[/TR]
[TR]
[TD]4 January 2013[/TD]
[TD]Jan[/TD]
[TD]Testing[/TD]
[TD]Test bed removal Rework[/TD]
[TD]Test bed removal [/TD]
[TD]Gear noise.[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]30 January 2013[/TD]
[TD]Jan[/TD]
[TD]Testing[/TD]
[TD]Test bed removal Rework[/TD]
[TD]Test bed removal [/TD]
[TD]Gear noise.[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]12 January 2013[/TD]
[TD]Jan[/TD]
[TD]PDI[/TD]
[TD]PackingRework[/TD]
[TD]Packing[/TD]
[TD]Rocker cover mounting nuts observed loose.[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]21 January 2013[/TD]
[TD]Jan[/TD]
[TD]PDI[/TD]
[TD]PackingRework[/TD]
[TD]Packing[/TD]
[TD]Alternator lever mounting bolt spring washer missing observed[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]4 January 2013[/TD]
[TD]Jan[/TD]
[TD]Assembly[/TD]
[TD]B/oReject[/TD]
[TD]B/o[/TD]
[TD]Dent mark on gear support.[/TD]
[TD]2[/TD]
[TD]Reject[/TD]
[/TR]
[TR]
[TD]5 January 2013[/TD]
[TD]Jan[/TD]
[TD]Assembly[/TD]
[TD]B/oReject[/TD]
[TD]B/o[/TD]
[TD]Oil seal housing mounting dowel hole CD minus[/TD]
[TD]6[/TD]
[TD]Reject[/TD]
[/TR]
[TR]
[TD]6 February 2013[/TD]
[TD]Feb[/TD]
[TD]Assembly[/TD]
[TD]AssemblyRework[/TD]
[TD]Assembly[/TD]
[TD]M.B. cap mounting stud threading spoiled.[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]13 February 2013[/TD]
[TD]Feb[/TD]
[TD]Testing[/TD]
[TD]TestingRework[/TD]
[TD]Testing[/TD]
[TD]Lub oil leak from Rocker cover joint.[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]4 February 2013[/TD]
[TD]Feb[/TD]
[TD]Testing[/TD]
[TD]Test bed removal Rework[/TD]
[TD]Test bed removal [/TD]
[TD]Lub oil leak from gear end foot mounting stud( L.O.P filter side)[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]4 February 2013[/TD]
[TD]Feb[/TD]
[TD]PDI[/TD]
[TD]packingRework[/TD]
[TD]packing[/TD]
[TD]Water observed in oil filling body.[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]22 February 2013[/TD]
[TD]Feb[/TD]
[TD]PDI[/TD]
[TD]packingRework[/TD]
[TD]packing[/TD]
[TD]Alternator belt tension bolt observed wrong(req. 50.003.08.30, obs 50.003.08.25)[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]1 February 2013[/TD]
[TD]Feb[/TD]
[TD]Assembly[/TD]
[TD]B/oReject[/TD]
[TD]B/o[/TD]
[TD]Rusty observed .[/TD]
[TD]7[/TD]
[TD]Reject[/TD]
[/TR]
[TR]
[TD]11 March 2013[/TD]
[TD]Mar[/TD]
[TD]Assembly[/TD]
[TD]AssemblyRework[/TD]
[TD]Assembly[/TD]
[TD]D262' Engine assembly no. not punched (Missing).[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]16 March 2013[/TD]
[TD]Mar[/TD]
[TD]Testing[/TD]
[TD]AssemblyReject[/TD]
[TD]Assembly[/TD]
[TD]Water inlet manifold tapping spoiled.[/TD]
[TD]1[/TD]
[TD]Reject[/TD]
[/TR]
[TR]
[TD]25 March 2013[/TD]
[TD]Mar[/TD]
[TD]Testing[/TD]
[TD]TestingRework[/TD]
[TD]Testing[/TD]
[TD]Lub oil leakage from end cover.[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]30 March 2013[/TD]
[TD]Mar[/TD]
[TD]Testing[/TD]
[TD]TestingRework[/TD]
[TD]Testing[/TD]
[TD]Engine not taking torque load, then also engine passed & sent for packing.[/TD]
[TD]2[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]4 March 2013[/TD]
[TD]Mar[/TD]
[TD]Testing[/TD]
[TD]Test bed removal Rework[/TD]
[TD]Test bed removal [/TD]
[TD]Blow by High [/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]13 March 2013[/TD]
[TD]Mar[/TD]
[TD]Testing[/TD]
[TD]Test bed removal Rework[/TD]
[TD]Test bed removal [/TD]
[TD]Low idle rpm high (2500rpm.)[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]28 March 2013[/TD]
[TD]Mar[/TD]
[TD]Testing[/TD]
[TD]Test bed removal Rework[/TD]
[TD]Test bed removal [/TD]
[TD]Lube oil leak from Gear casing Stud hole.[/TD]
[TD]2[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]4 March 2013[/TD]
[TD]Mar[/TD]
[TD]PDI[/TD]
[TD]packingRework[/TD]
[TD]packing[/TD]
[TD]Alternator mounting bolt washer missing[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]30 March 2013[/TD]
[TD]Mar[/TD]
[TD]PDI[/TD]
[TD]packingRework[/TD]
[TD]packing[/TD]
[TD]Engine Serial number punching wrong (Observed 39.354 instead of 39.1354)[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]2 March 2013[/TD]
[TD]Mar[/TD]
[TD]Assembly[/TD]
[TD]b/oReject[/TD]
[TD]b/o[/TD]
[TD]Cylinder head observed without valve guide[/TD]
[TD]1[/TD]
[TD]Reject[/TD]
[/TR]
[TR]
[TD]2 March 2013[/TD]
[TD]Mar[/TD]
[TD]Assembly[/TD]
[TD]b/oReject[/TD]
[TD]b/o[/TD]
[TD]Oil seal housing joint observed cut[/TD]
[TD]2[/TD]
[TD]Reject[/TD]
[/TR]
[TR]
[TD]30 March 2013[/TD]
[TD]Mar[/TD]
[TD]PDI[/TD]
[TD]b/oReject[/TD]
[TD]b/o[/TD]
[TD]Cap crack observed[/TD]
[TD]1[/TD]
[TD]Reject[/TD]
[/TR]
[TR]
[TD]6 April 2013[/TD]
[TD]Apr[/TD]
[TD]PDI[/TD]
[TD]AssemblyRework[/TD]
[TD]Assembly[/TD]
[TD]Water inlet manifold mounting bolt observed loose[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
[TR]
[TD]27 April 2013[/TD]
[TD]Apr[/TD]
[TD]Assembly[/TD]
[TD]AssemblyReject[/TD]
[TD]Assembly[/TD]
[TD]Lub oil leak from FIP lubrication pipe mounting hole.[/TD]
[TD]1[/TD]
[TD]Reject[/TD]
[/TR]
[TR]
[TD]12 April 2013[/TD]
[TD]Apr[/TD]
[TD]Testing[/TD]
[TD]TestingReject[/TD]
[TD]Testing[/TD]
[TD]Engine seize.[/TD]
[TD]1[/TD]
[TD]Reject[/TD]
[/TR]
[TR]
[TD]8 April 2013[/TD]
[TD]Apr[/TD]
[TD]Testing[/TD]
[TD]Test bed removal Rework[/TD]
[TD]Test bed removal [/TD]
[TD]Lube oil leakage from RS pipe mounting face on cylinder head[/TD]
[TD]1[/TD]
[TD]Rework[/TD]
[/TR]
</tbody>[/TABLE]

 

[ejronin]

Let me see if I understand your process correctly:

You want data to export FROM this sheet TO another sheet based on specific values of a specific column in this sheet - (i.e. full row values taht match criteria X of colA, copy to sheet B, paste col A)?

I'm not certain VBA is the practical solution as Pivot Tables with slicers are for this exact kind of thing. Maybe if I understood the logic process of the data start and end points I could help a little better in terms of it all.

 

[nits1982]

Thanks yes i want to extract certain data to certain sheets for example testing rework should come to testing rework sheet can we use if and index for this.

 

[Smitty]

Thanks yes i want to extract certain data to certain sheets for example testing rework should come to testing rework sheet can we use if and index for this.

Welcome to the Board!

The advice to use Pivot Tables is spot on. Separating data from it's source will only cause problems in the long run. If you need to have individual sheets for each item, then build a master pivot table and put that field in the report Filter field. Then you can goto Option-->Show report filter pages, which will create a new pivot table worksheet for each item in the list. The nice thing about this is as you add new data all you do is refresh the pivot tables to update.