macros

  1. M

    Edit CSV file adding double quote via macro

    Hello, i have created an excel file where there is a button and when the user presses it, it prompts a window for the user to select a CSV file to be edited. After the file is selected i make some changes and save it to a new csv file that works fine, but i struggle to add double quotes (") to...
  2. M

    Copying contiguous & non-contiguous cells using SpecialCells in VBA

    Can anyone please assist me on this request and here's the link for it: https://stackoverflow.com/q/76588334/13644020
  3. P

    Existing macro to password protect sheets has stopped working

    Hi all, I'm hoping someone can help me troubleshoot why a macro that has been in use for >4 years without any issues and hasn’t had any recent changes to the coding, has stopped working for some users while still working for me. The main purpose of the macro is to password protect each sheet...
  4. D

    VBA To Copy a sheet into another workbook with formulas without reference

    Hello, i am wondering if there is a way that when copying a sheet into a new workbook, and the sheet i am copying has formulas. Is there a way to do this and not have the references in the formula of the new workbook when bringing the copy over? Here is the code i use to make the tab in the new...
  5. I

    Microsoft Excel - REQUIRE MACROS

    Hello, Mr. Excel users! Excel w/ VBA are such a great duo when used in tandem. It seems one is able to lock out all use of Excel via VBA events and also use Auto_Open() to bypass the application.enableevents if it set to false. However, the one issue I am running into time and time again is that...
  6. An Quala

    Delete date in 3 sheets once we run the macros

    Hello, can anyone please write me a code which deletes the date in the 3 sheets present in same workbook, the sheet names are "Sheet1", "Sheet2" and "Sheet3". Please note that only data needs to be deleted, not the sheets themselves. Thank you.
  7. T

    HyperLinks to folders with the same name as excel cell value

    Hi MrExcel community, this is my first time for posting here. Though I know the topic about matching(look up) and hyperlinks in VBA Excel has been repeated a lot. I have a macros that I would love to ask on how to code which I will explain the criteria of it down below with a picture for better...
  8. W

    How to automatically hide/unhide columns based on criteria with VBA

    Hi I used the following code to automatically hide/unhide rows based on conditions but do not have the skills to also apply this to columns. Public Sub Worksheet_Change(ByVal Target As Range) Dim r As Long Dim m As Long If Not Intersect(Me.Range("B7:B200"), Target) Is Nothing Then...
  9. R

    Payroll Macros

    Hello! I was wondering if anyone has an existing macro or made one in the past for payroll. I attached a screenshot of what it would look like so you just input the time in and time out for each employee and then it would calculate the time when you hit the calculate button and add the total...
  10. M

    Macros to triggger timestamp whenever one specific option is selected from the drop down list

    Hi All, Hope you are doing great I need your help to create a Macros to trigger timestamp whenever one specific option is selected from the drop down list I have a file called Employee(Copy) where is already a event macros to copy and paste the values in the another file. So, I wanted to...
  11. brendalpzm

    Vlookup function in two text box

    I have 2 text box (not a user form) in one text box the user is supposed to type the employee number (TextBox1) and when they click on the "search" button, it should bring in the TextBox2 the name according to the employee number. The sheet where the textboxes are located is called "Input" and...
  12. I

    Teams Meeting invitation via Excel VBA

    Hi All, Is it possible to send Teams Meeting invitation with Microsoft Outlook email notification via Excel VBA? For example, I have a file which contains the columns below: Column A: subject - teams meeting's subject Column B: participants - participants who should attend the meeting, each...
  13. E

    Adding text to different cell using Macros

    Hi, I have recorded a macros Sub WarehouseRecieved() ‘ ‘WarehouseRecieved Macro ‘Booked in at the warehouse ‘ ‘ Keyboard Shortcut: Crtl+w ‘ Range(“Q21”).Select ActiveCell.FormulaR1C1 = “Yes” End Sub BUT!! I want to select a different cell (column b) run the shortcut and yes to appear...
  14. R

    Task Scheduler fail to open excel and run macros

    Hi, I am facing problem for Task Scheduler to run a excel macros. When I run the Vbscript in Task Scheduler, the status shows running but nothing happen. I open the excel file manually and it shows below reasons, so i have to end the excel using task manager to let me access to the file again...
  15. C

    Consolidation

    I would like to consolidate columns A2:I2 based on the criteria that A2:D2 are the same on the next row. I have attached photos of the whole document to provide how this is supposed to work. I cannot seem to figure out consolidation and I maybe overlooking it. I have the code pasted below...
  16. S

    Is there a way to uncheck a checkbox with a macro?

    I have a button with macros that clear cells to reset a form. Is there a way to have that button clear a checkbox as well? Note that it couldn't just change the state of the checkbox as it won't always be checked when the form is reset. I can't find anything online that leads me to believe this...
  17. M

    How can we use VBA/Macros Excel for solving this interesting simulation question related to probability distribution?

    Imagine that we have 100 pens in our box (each numbered from 1 to 100). We mix them and then randomly draw ten pens and put them aside. Afterwards, we put ten new pens numbered from 101-110 into the box, and then again randomly draw other ten pens and put them aside. We continue doing these...
  18. E

    How to automatically group changing data ?

    I work as a sales data analyst for a clothing manufacturer. And I often make sales reports that are structured by Brand-season-Category. I constantly have to manually select rows and group data. Maybe there is a way to write a macro to do this automatically ? A macro with constant strings will...
  19. Chris_010101

    Get Macro to Work on Multiple Sheets

    Hello, The below macro is assigned to a button on the ribbon and works on the "current 6 months" sheet. It looks down column B for "terminated" and deletes the row. It's currently restricted to only work on "current 6 months" sheet. Is there any way to add another sheet "Previous 6 months" to...
  20. S

    How to publish pivot table selected filter in Excel

    Hello, we have been using a pivot table to create interval level data for a report. The user selects which historical weeks should be considered and what activates should be included in the pivot table options. is there a way to have the selected filters published in list form? Essentially, I...

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
Back
Top