Tag Archives: Excel

Excel VBA, Macro, Excel

I have Excel WorkBook Named .Within this WorkBook there are 2 Work Sheets: Sheet1 – Named “Client Code” Sheet2 – Named “Client Data” NOW Sheet 1 “Client Code” Contains Client Unique Codes in Column A (For Example as under): Client … Continue reading

Export selected fileds to excel

Hello, I am trying to export selected data to excel (.xls) , but it displays all the fileds from the database. I am not getting how to select only few columns. Here is the code Form Code: ———

How to save excel file faster with VBA

I have an excel file worth 150 mb and with only one worksheet( master worksheet).As you can imagine it has lots of calculations in it. What I am doing currently is, running a VBA in it to make a new … Continue reading

Convert pdf Statement To Excel

I require a number of locked pdf bank statements converting into one excel spreadsheet with accurate formatting We have a company account with a large number of cheque transactions appearing on our bank statements We need each statement converting onto … Continue reading

Combining search, IF and OR in excel

Have an excel file like this: armchair 3 wheelchair 1 stool 1 bench 1 sidetable 2 table 0 plate 2 I want to search for multiple part of words, and then return the value in the second column. In this … Continue reading