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
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 |