• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter the specific column on basis of criteria and populate the few column in a new excel workbook

Status
Not open for further replies.
A

AmitSingh

Member
Hi All,

Need help to extract the 8 column from the input file name "TestProduct_DELOITTE OI-421564 RMTv15_checked01.xlsm" and past it to next workbook sheet by the name starting with "Product_TestProduct_DELOITTE OI-421564 RMTv15_checked01.xlsb". Filter to be applied in LOB column (I13) with "Product Line". After filter only, below columns to be pasted from one sheet to another workbook.

Name of column to be extracted from Input file are below:-
Salesforce ID from Cell I4
Start Date from Column T13
End Date from Column V13
LOB from Column I13
Resource Source from Column O13
Roll Title from Column M13
Region/Country from Column L13
Master Roll Code from Column X13

I have attached the Input file. Please help me as it is little urgent.
Thanks in advance.
 

Attachments

  • TestProduct_DELOITTE OI-421564 RMTv15_checked01.xlsm
    459.1 KB · Views: 1
Status
Not open for further replies.
Back
Top