1. R

    How to copy all the unique values to another excel sheet using 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...
  2. A


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

    VBA code to compute MAX and Average of a range of cell

    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!
  4. G

    Non Volatile way (macro) to conditionally color cells by date and index

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

    Need a macro to conduct some steps for each part number in a column

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

    Align zero on secondary axis with primary

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

    A Macro that imports row data from another sheet?

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

    Copying column with conditional formating VBA

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

    VBA Error Code '5' Invalid procedure call or argument

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

    My email vba macro does not work

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

    Create fill-in-the-blank Japanese sentences using Excel. 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...
  12. F

    Macro copy and paste based on condition

    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)...
  13. B

    Open an Excel file with macro

    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]...
  14. B

    Search a word in a worksheet and store the location

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

    Append/combine multiple worksheets from workbooks into one workbook

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

    Save excel sheet as PDF (only one sheet)

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


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

    Filter messes with VBA

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

    Macro button to open up a pdf based on cell value

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

    Excel VBA macro to add a new row every 20th row from A2 not A1

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back