Search results

Hi , Anybody help to retrieve pivot data table to mail body in outlook -> I want to create pivot table from data and covert pivot range table data to mail body and delete blank column from pivot table

How to open outlook with subject line "Report-02/16" and read table data in body of mail or export table in excel using VBA

I want to filter the column value which should not contain string starting with "Bank", "HDFC", "SBI" trying to do below code but not getting required results Activesheet.Range("$A$1:$CT & lastRow").AutoFilter Field:=13, Criteria1:=Array("<>Bank*", "<>HDFC*","<>SBI*")

Getting update , not update pop up despite of keeping "Application.screemupdating= False" in the beginning of code. Is there something else i need to keep?

First i am creating pdf files from excel format sheet and it is getting save in one folder ....... 1)If pdf file in folder is more than 30 then it should merge all pdf files into one pdf file can anybody suggest how to do this using vba ? I did below Code: Sub CreatePdf_form() Dim str AS...

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

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

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

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

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

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

Hi, I am facing issues in converting excel rowwise data in pdf format In excel(InvestorData_06/05/20), i have below data and i want to zip loan wise data in pdf format(If 2 loan is there then 2 pdf file should come) with same folder name as excel name. ID Date InvestorId loan 44030...

Hi, i want to filter column having date format in "dd-mmm-yy" Column range :=E1 and autofilter field:=5

Anybody tell me how to delete spaces from drop down list . i did code like this: with sh1.range("A2").validation .delete .Add type:xlvalidateList, AlertStyle:=xlValidAlertStop, operator:xlBetween, Formula:"=sheet2!AH2:AH1000" .IgnoreBlank=True .IncellDropDown=True .InputTitle="" .InputMessage=...

I have opened workbook using macros in access and want to do below steps 1) I have workbook open with some specific columns, i need validation on first column and it should take data from another sheet(distinct value) 2)how to take data in another sheet from query

Hi, i am facing issues to copy headers from two table in access and paste to open workbook. KIndly help me

Hey, i am beginner on access database want to learn more related to macros stuff :)