Copy and Paste from other Workbooks

rubic

Active Member
Joined
Jul 9, 2008
Messages
251
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
ABCDEFGHI
2
3
4WPNo.MBSClaimRef.No.Contractor'sNoticeProjectManager'sInstruction(ifapplicable)StatusofProjectManager'sassessmentRemarks
5ClaimRefNo.dateletterrefdescriptionPMIno.daysCode1,2or3(refertonotea)
6
724072407/EOTC/0012-Nov-07LETTER-000019NotificationofDelayduetodisruptionofworksNA112days1
824072407/EOTC/00211-Oct-08MCD-EMAIL-000660[2959/0071L/2008/102/phe]NotificationofpotentialdelayduetolateremovaloftemporarycofferdamNANA1
9
WP8402
 

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
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!
 
Last edited:

Forum statistics

Threads
1,077,784
Messages
5,336,327
Members
399,076
Latest member
vullistax

Some videos you may like

This Week's Hot Topics

Top