macro

pincode vendor rating pending cases 1 xyz 2 0 2 xyz 2 41 3 xyz 2 45 1 xyz 1 4 2 xyz 3 17 4 xyz 2 0 5 xyz 2 45 6 xyz 3 17 This is my excel data i want to copy all the unique data of pincode to another excel sheet.. For eg. here there are pincode "1" which has 2count then all...

Hi guys, After reading a lot around here and many beginner fails, I give up and kindly ask for your help with the below. I need a macro to add specific values (let's say d/e/f) on the 2nd row after the last used column, in specific colors. Should be something like this, but something is...

Hi All, Sorry if this is a silly question but I'm fairly new to VBA and macro in excel. I would like to know what is the VBA code on computing Maximum and/or Average value of a range of cell in another workbook and then show the result to a cell in another workbook also. Thanks!

Hi, I have a very large worksheet that has gotten too big and too slow so I am trying to get rid of formatting and volatile functions among other things where possible. I currently use the built-in conditional formatting to achieve the result mentioned below and would like to find a way to do...

I have an Excel sheet with 12 columns and 4000+ rows. In Column E, I have a list of part numbers. These part numbers may or may not be repeated based on the city names found in Column F. For example, Part A (located in Column E) may be in 3 different rows: one row for City X, one row for City Y...

Hi, I am running a macro to create some charts, my orange line is on the primary axis with the blue and purple are on the secondary. I need the secondary zero point to start at the same as the primary, is there a change to my VBA code that would do this?? Also... how do i change the colour of...

Hi everyone, I need a Macro that populates a range of cells with a formula. At first, I thought this would be an easy problem... but I'm starting to think that it is a more advanced problem than I originally guessed. To explain: In my spreadsheet, I have two sheets: PERM_DATA and...

Hi, I have made a sheet to check results from a water test against a limit. I started with one column where you insert the results from the test. And if the result is higher than the value written under Grenseverdier Bærum Kommune then the cell becomes red, if its under the cell becomes green...

Hi, I'm hoping someone can help. I don't have a lot of experience with creating macros on Excel but I have been following a tutorial to create tabs in a sheet. The idea is when someone selects one of the tabs for example, sale by revenue/sales by units, the relevant graph will appear. The code...

Hi all, I have the current VBA code: Option Explicit Private Const FilePath As String = "S:\File Path anonymous\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim col As New Collection, itm As Variant Dim...

https://www.mrexcel.com/board/threads/create-fill-in-the-blank-sentences-with-xl.239288/ Hi there, The macro above works fantastic for English text, but I am unable to get this to work with Japanese text. I am hoping this macro may also be used for French text. The desired output would look...

I need a macro that does the following. - if there is a value in A3:E3, it copies and pastes to the corresponding cell in table 1 based on the date in A2:E2 and the corresponding date in E9:E11 in this example, copy and paste from C3 to D11=4,000,000 (August) and E3 to D13=4,000,000 (October)...

Hello guys, i need some help. I have to open an Excel file with a macro thanks to a path. I explained : I have, store in a variable, this : [LLD] -[SD2022_LP34.3_WDM_P1_CTA_BRO SAVOIE_EXTENSION_OMEGA] [LLD] - [NOE]- [SD2022_WDM_P0_NOE_Raccordement-Belfort-RIP-Altitude-Doubs-Dijon_CREATION_RIP]...

Hello everyone, I need to create a macro to find in a worksheet the location of every cells which contains "ETH" ( the location can change) and store each in a variables in order to use it after that . Like the picture below. Thanks guys :D

Dear Patrons, Newbie here. I want to append/combine the highlighted worksheets- 5 int & 7 lql (screenshot Item 1) from multiple workbooks - 20220601, 20220602, 20220603.........(screenshot Item 2) into two worksheets in a new empty workbook - Master File (screenshot Item 3) . Any help is...

Hi all, I currently have a macro that converts my excel sheet into a PDF and saves it in a designated folder. However, I only want it to save the first sheet as a PDF, and ignore my other sheets, which it will not do at the moment. My code looks as follows: Option Explicit Sub...

Hi everyone, I'm struggling with this for several weeks now. I hope someone can help me out. I have a feeling it's possible but it's quite challenging. For my job I must put article data in Excel file and enrich/adjust it. I have created a Template for this with several macro's. When this is...

Hello, I am using the below code, which moves a row to another sheet based upon the value of a drop-down list item. However, if the data on the sheet the row is moving to is filtered, instead of adding the copied row to the first blank row at the bottom of the data, it overwrites a row of...

HI, I am wanting a Macro button setup so that when a value is entered into cell E1 and then the button is clicked, a pdf opens up from a folder on X drive. Refer below snip. (Ignore the Display and Reset buttons, I am just after the Layout button) Can anyone help me with this please ...

have a code that misses row A1 and then adds 20 rows after this. I need the code to add 20 rows after A2 Sub AddRows() ScreenUpdating = False With ActiveSheet lastRow = .Cells(.Rows.Count, "A").End(xlUp).Row End With Dim AddRows As Integer: AddRows = 20 Dim i As Integer: i = lastRow Do While i...