macros excel vba

Current: I have code that updates 4 tab (Sheet6, Sheet7, Sheet8, Sheet10) names based on cell values in range D2:D5. This range is populated with formulas, which can result in blanks and is located on a tab named “Calculations”. Each cell is associated with a specific tab: D2 -> Sheet6. If...

I have a pivot table and I need to show the underlying data ( show detail feature of pivot table) for all pivot values in table into a single new sheet instead of creating a new sheet for each cell value. So far I got this code from a site which loops thru all cells but creates new sheet for...

Hello I have limited knowledge with macros so would appreciate any advice you can give me. I have a Workbook that has several users - most only need to view the Workbook, others need to edit certain columns. I would the columns that need to be edited hidden on opening and only visible once...

Hi All, I cannot seem to figure out how to get this code to work multiple times on the same Worksheet (I am definitely a beginner when it comes to VBA). So much so, that an awesome member helped out on this forum with the below code to hide and show rows (2-43) based on a number entered into a...

ch as string ch = ch & "}}}],""must_not"":[{""query"":{""match"":{""work"":{""query"":""****"",""type"":""phrase""}}}},{""query"":{""match"":{""work"":{""query"":""****"",""type"":""phrase""}}}} I would like to split it into many lines. How do I do it ? I tried using underscore but it...

Hi, I have this code that finds the specific work from the column selected in the listbox. The problem I am facing is it only highlights if the cell has that word only once. If the cell has the same word multiple times it is not highlighting those. Here is the code Dim rng As...

Hey guys, I have an excel template with 83 different columns. Each column has different conditional formatting rules (for example, one column has to be under 17 characters and cannot contain I or Q, another column can only contain "AA" or "BB" etc.) I receive different versions of this excel...

I have 8 macro buttons that simply change the value of one cell - [D13] to States ("NSW","QLD" ...) When this happens (ignoring the other functions) the button text turns white (from Black) all relevant code: '------------------------------------------------------------------' 'Sub...

Hi I have 2 sheets in my workbook. Sheet 1 has list of IDs and incomplete cells in address field. In my sheet 2 I have Another list of addresses that are fully written and I want to mark the ID if I think that it is matches. The address in sheet 2 can repaeat and evertime the same id is to be...

Hello Guys I have a complicated Questing which I am not able to solve Please Help Me out: =IF(VLOOKUP(AO4,Matrix!$A:$AG,MATCH(AP4,Matrix!$A$3:$AG$3,0),0)="X","match","To check") I need above code in VBA and I am sharing all my VAB codes below Sub Execute1() Dim ws_zfi As Worksheet...

OS X Yosemite 10.10.5 Excel 2011 version 14.7.2 (170228) on MAC Am running the below macros in module 4 as an end of month worksheet cleanup, and have been getting "Out of Memory" messages. How can this be fixed? Sub ClearCheckbookEntries() Range("V5:Y54,AB5:AE54").Select...

Hello, Thank you in advance for taking time to review my question. I have a list of emails exported from Outlook to a .CSV file and I am trying to extract data from the "Body" cell and paste it into corresponding cells on a different sheet. Each email contains somewhere in the body this...

Team, My excel file with macros is working just fin in my laptop (configured for US English language) but the same file throws below error message when my colleagues in Paris with French OS try to open it. Error Message: “Excel encountered non readable content in the file. Do you want to...

I'm well experienced with Excel but I'm fairly new to VBA. I have a userform that will enter values into the next empty row when the "Enter" button is clicked. The issue I'm having is that, after the next empty row is filled, if the user hits the enter button again it fills the next row with the...

Dear Experts, Am looking forward to get clarified on a excel vba macros code. Below is my actual requirement, 1. I will have 3 combobox (Which everything is inter dependent --- Combobox2 is dependent on Combobox1, Combobox3 is dependent on Combobox2) 2. I will have a textbox created at the...

I am trying to write a macros so that a given column will autofill a given range based on the last cell. Below is an example to better explain what I need: Michael Michael Richard Richard Tyler Sam Sam Billy Billy Chad Chad Pretend these given names are all in the same column (lets...

Hi Experts, I am using one of the sheet of Excel as DB (Sheet Name - Database) and another sheet as User Interface (Sheet Name - UI). The User as flexibility to search the data based on filter selection. There are 5 Combo Box filters. Everything is working fine. Apart from one unusual problem...

Hi all, I have a excel workbook with 5 worksheets, based on designations I want to show the data related to them, -> like Project manager should be able to see all data and report. -> group head should be able to see the summary/report. -> business unit should just see report. so for this I...

Hi so this is my chart and x stands for a number (BTW my table has more than this many columns and rows): Countries 1 2 3 4 5 AMS Canada x x x x x U.S. x x x x x Mexico x x x x x Europe Italy x x x x x France x x x x x Germany x x x x x Russia x x x x x APP...

Hi, I created a macro that copy and paste information into another workbook based on a dropdown selection made by a user. Once the selection has been chosen the user can run the macro and it will copy the information selected into a separate book and formatted. However, if the user then wants...