Search results

In one folder(F:\Bank\Formdetails\) multiple files are there in pdf and excel format, want to zip only if same string name found in pdf and excel 1) If excel name is "Dbk_bank.xlsx" and pdf is "Investor_Dbk_bank.pdf" then it should do zip in path (F:\Bank\Formdetails\) with name Dbk.zip 2)If...

After removing SubField:=0, It is working fine ...thank you :)

This code is working fine . Thank you :)

I am working on project which should open workbook and filter column on the given criteria using vba thank you

Hi @arnelgp , could you please help me on this thank you

I Want to filter column A with name like "ESAF", "E S A F" OR any name like "FBI *" column contain "ESAF", "E S A F" or ("FBI Bank", "FBI Bank ltd", "FBI Finance ltd" can be more with FBI*)

Hi anybody please help me on this: i have column name Orderdate and i want to apply filter from last month till yesterday date if today date is 07/18/20 then it should filter from 06/18/20 to 07/17/20 confused how to do autoflter

Hi anybody please help me on this: i have column name Orderdate and i want to apply filter from last month till yesterday date if today date is 07/18/20 then it should filter from 06/18/20 to 07/17/20 confused how to do autoflter

Hi approach is correct but it is deleting all rows please find screenshot below for output result i want SR Loan_number ID bank_name city 1 1110002 234 DB bank 2 1110002 445 -need to delete as city and bank_name is empty 3 1234000 66 NY 4 1234000 344 -need to delete

Hi, need to delete whole row please find below screenshot SR Loan_number ID bank_name city 1 1110002 234 DB bank 2 1110002 445 - need to delete as nothing is there in bank_name & city 3 1234000 66 NY 4 1234000 344 -need to delete

Working on lookup main file data from another workbook data contains order date ->lookup is only for last one month data , want to filter Order Date column for the past one month date format(ex- 06/10/2020 to 07/11/2020)

I want to remove duplicates loan number from column B only if column name D "Bank Name" is blank or column name " City" is blank using vba

Could you please chk my post again there itself i have edited

mentioned complt requirmnt

I have folder with same today date want to covert that folder to zip and attach to mail using vba. I have sub folder inside folder name 2020, with today date and there are pdf files are inside that like below scrrenshot in datefolder loan pdf files are there, and in excel folder same count...

yes its done

I want to set Range("E") of excel after filter with values "Duplicate" using vba Can anyone help me with this?

I did below code but facing error Sub Investor_Code() Dim wsDest As Worksheet Dim ws As Worksheet Dim LrowData As Long Dim Autofiltng As Range Dim Rng As Range 'Destination Set ws = ThisWorkbook.Sheets("sheet1") Set wsDest = Workbooks("Investor_code.xlsx").Worksheets("Sheet1")...

Hi I have two workbook and i want to filter one column range only if that value present in another workbook 1)Please find below screenshot, it is present in workbook investor_Code 1)On the basis of above investor code i want to filter below workbook data which is Loan_Details

yes have to research lot of things