vba code

Hi, so I need to delete the complete row if specific criteria is met, the criteria is as follows, In a sheet named called "Data" If column B contains either of "John", "David", "Susan", "Macro", few of them, or all of them, then delete those specific rows leaving the others (Note: If any of...

Hello there. I am a bit rusty with Excel and VBA following differing jobs not needing it so much, however I am now currently in a role where using advanced Excel and VBA would be extremely beneficial. I am currently stuck on something which I am guessing is reasonably simple, and google is not...

Hi, I am not sure how to do this. I have code that is exporting a spreadsheet as a CSV file, but I would like to name the file based on information in Cell J2 on a spreadsheet within the workbook called Int_Check. Can you please help me modify the code to rename the exported file. I would like...

Hi all, I am working on a macro to save off a file. We would like to pull a few cells of data from a spreadsheet into the name of the spreadsheet. The start date is in cell B3 on the INPUT tab. How can we pull this into the file name using VBA? I think the dashes will cause a problem so we can...

Hi All Please advise on a VBA code which i can use with Index Match for conditional formatting. my conditional formatting formula is as below =(Combined!$A2=INDEX(Summary!$A:$A,MATCH(Combined!$A2,Summary!$A:$A,0))) I want to highlight cells (any colour) if any cell in Column A from the...

Hi all, I currently have the following setup: I have marked everything that I want to be exported into a PDF, which works when I manually save the file as a PDF. However, I do also have a macro ("Save file to folder") as seen above, which saves the file (albeit as an Excel file) to my...

Hi all, I have this VBA code to write an email body text: eBody = "Dear person," & "<BR><BR>" eBody = eBody & " 1Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text (Text text...

Dear all, I am currently working on a spreadsheet that looks like this, albeit the real one is much larger: I was wondering if there would be some way in which I could create a macro or some VBA code attached to a macro where, once i press it, it takes the e-mails from C2-C12 and takes the...

Hi! I could really use some help ASAP . This project is due in 24hours and I have yet to find or work out a solution to my problem. I have a task manager workbook with several worksheets that I have created to allow for task management tracking based on completion dates. Weekly, monthly...

This code was written for me by @Jaafar Tribak . I want to update it at the line below but I am not able to do it as I want. sFolderPath = ThisWorkbook.Path & .PathSeparator & "PASSPORT PICTURES" & .PathSeparator Instead of compressing from the parent folder, "PASSPORT PICTURES", I have...

Hi, I need a VBA code that copies data from a 'master sheet' and pastes it into the relevant sheets. The 'master sheet' is named "BCA" and then I have many sheets that are renamed according to the value of ("AZ1") in their respective sheet. What I need is a VBA code to, for each sheet, search...

Hi, I am not very proficient with VBA code (hence why I am posting this). So I have a workbook that automatically copies and pastes all the data on the first sheet to every other sheet when the first sheet has data pasted into it. What I need now and can't figure out the most efficient way to...

I want to change the order of a string such as 32cd4f18 so that it gives an output of 23dcf481. So the string should be swapped in pairs. If someone could help me with a VBA code that would be very helpful.

Hello, I created pivot charts through power query and every month I add new info to the database and the charts update. They are line charts comparing two values. The problem is: when the charts are updated with new values, sometimes the data labels overlap... is there some vba code to prevent...

I am hoping someone can assist me with this question. I have attempted to construct code to attach to a sheet in my excel workbook based on information I have gleaned from internet searches and forums . What I am trying to achieve is for the sheet to automatically place a copy of a row from an...

Hi, so I am trying to find which item was purchase for each order. And so the drop down list in in column C and I am trying to allow multiple selections with repetitions. But once I put in the code, for some reason it would either NOT update or the code is not working. This is a code I found on...

I have searched the internet tirelessly for an answer to this question that I desperately need more understanding on. What I am trying to do is create a macro that will take raw data on one sheet and put it into a pivot table on a new sheet - pretty standard procedure right? The issue is that...

Hey all! SO far i tried this vba code and it works, but the cons is that it only works for 12 rows and i want is to make like it works for a bigger amount of rows. I am kinda new to this things and just trying to figure it out. What it does is its reads cell value in J5 and if that value is...

Hi all, I am new here, but couldn't find the answer in previous posts. Feel free to send a link to an old post solving this issue if you know of one! Now to my problem. I want to link two worksheets in the same document, whereby if changes occur in A, the changes should also be entered in B...

Hello, I am trying to see if there is a way to have a module in VBA that runs different modules that have different subs(), I am going to put that into a button a user can press to do so Example: Say it is called MasterMod I want mastermod to run Mod1 Mod2 Mod3 Mod 1 has code for sub Name1()...