macrco

  1. S

    Excel vba loop to find records matching multiple search criteria and multiple sheets

    Hi @all, I would like to implement the following function in VBA as a procedure. =INDEX(Zones!$G$3:$S$273;MATCH($A3;Zones!$C$3:$C$272);MATCH($B3;Zones!$G$2:$S$2)) I have two sheets ("Data" and Zones"). I search in the sheet Zones for zone numbers, to be able to determine later also the...
  2. P

    Macro that generates 8 digit random hexa on a given input

    Hi there, I'm looking for a macro which generate an 8 digit hexa number on a given input numbers. But before generate a random hexa-number, check if particular input is already in a cell (for example row 12) in column A, corresponding to that cell value (cell 12)in column B will be added in...
  3. rediffusion

    How to adjust the size of the `Note` after opening it?

    Cross-post ! So here is macro: Private Sub NoteZoom3() With ActiveWindow.VisibleRange NoteChangeSize .Width, .Height, True End With End Sub Private Sub NoteChangeSize(w!, h!, Optional scr As Boolean) With ActiveCell.Comment.Shape .Width = w: .Height = h...
  4. A

    VBA code to merge every three rows starting from second row

    Hi everyone, I need a VBA code that would merge every three rows (if data exists) starting from row 2, and covering column range of A to lets say J. Many thanks in advance,
  5. L

    [VBA] Search worksheet for match and copy/paste

    Hi, I have two excel documents, "Book1" and "Book2". Book1 is exported from our business system. Book2 is a compilation of forecast from the businesssystem data that were exported. Today I have to manually put in the data from Book1 to Book2. I want to put a VBA Code in Book2 to import data...
  6. tlc53

    Macro to add date to column

    Hi there, Can someone help me write this VBA code please? In column K (from K9 down) I have dates or blanks. I want to be able to push a button (POST) and if column K has a date in it (ie. isn't blank) then today's date should be entered in column L (L9 down). Once this date is entered in...
  7. N

    Copy and Export to CSV of a Pivot table output..

    Hi experts, i am an newbie for the VBA and Power Query.. i will have to download reports from our old system and upload to new system everyday.. the downloaded file will have an pivot table output as below after cleaning data. what i need to be do is copy each output based on the kit no and...
  8. S

    VBA Code Creation in Excel

    Please help me on creating a macro which search multiple sheets in a workbook with a particular column name and display the count of values in that column and display in a new sheet with sheet name and the count. Here is my code, Sub Click() Dim sh As Worksheet, ws As Worksheet, LstRw As...
  9. S

    Macro Creation in Excel

    Please help me on creating a macro which search multiple sheets in a workbook for a particular column and display the count of values in that column and display in a new sheet with sheet name and the count. Thanks
  10. A

    Tweak create PDF code

    Hi All, The below code creates a PDF from a named range in cell A55 on the "Menu" sheet and saves this to a folder based in a value in cell A52 on the "Menu" sheet. What I'd like to achieve, is that if the value of cell A115 on the "Menu" sheet is "Zone" then output the PDF file to a path in...
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 MrExcel.com.
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 "mrexcel.com".
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
Top