Copy and Paste from other Workbooks

[rubic]

Another situation arises and this time I am trying to copy and paste from another workbook ("S:\Infrastructure Section\Commercial Management\PMI and Claims\MBS-11-005a and 005b - Claims Registers Rev. 1-Infrastructure.xls") in a sheet named as "Clause 14". For easy reference lets call this as the source. This source file contains a massive amount of data which for my purpose I needed only data from a few specific columns. For easy reference the target workbooks is found in ("S:\Infrastructure Section\Commercial Management\PMI and Claims\INFRA-EOT Summary.xls") in a sheet also named as "Clause 14".

The target file is a simplified layout of the source as the source contains too much information which I don't really need. I need to extract from the source all the data if column A contain "WP2407". So all rows will column A having "2407" will be extracted to the target but only from the following columns, A to F, S, T starting from row 10 at the source to row 7 at the target. A snapshot of the target workbook is shown here

Book1
	A	B	C	D	E	F	G	H	I
2
3
4	WPNo.	MBSClaimRef.No.	Contractor'sNotice			ProjectManager'sInstruction(ifapplicable)	StatusofProjectManager'sassessment		Remarks
5		ClaimRefNo.	date	letterref	description	PMIno.	days	Code1,2or3(refertonotea)
6
7	2407	2407/EOTC/001	2-Nov-07	LETTER-000019	NotificationofDelayduetodisruptionofworks	NA	112days	1
8	2407	2407/EOTC/002	11-Oct-08	MCD-EMAIL-000660[2959/0071L/2008/102/phe]	Notificationofpotentialdelayduetolateremovaloftemporarycofferdam	NA	NA	1
9
WP8402

 

[RalphA]

To me, the easiest thing to do is to simply copy the source file to the resulting file, then, delete columns F-R and all columns following T. Then, sort the first column, delete all the rows above the desired case number, then, all the rows below the desired case number. Done!