macros

Hi, I have a workbook. First sheet has dates September 1st 2023 to September 30th 2023 (a2 to a31). I have 6 comments in each cell of each row. (columns B,C,D,E,F and G). The next 30 sheets are for the thirty days of September, titled September 1st 2023, September 2nd 2023 etc. Using VBA I want...

Name Status Email Status2 Comments Carrier Chk1 James Smith Provisioned JamesSmith@gmail.com REGISTERED Luke VzW Christopher Anderson Disabled ChristopherAnderson@gmail.com PENDING VzW Ronald Clark Disabled RonaldClark@gmail.com REGISTERED VzW Mary Wright Provisioned...

Hi, I have a large data set on one sheet. The raw data file is about 40MB in size. I would appreciate your help in completing this as I have run into issues in preparing this report. Honestly, I feel very overwhelmed and scared of using macros 🫣 My Apologies I am unable to add XL2BB to my...

Hi I make fairly extensive use of workbook event macros such as Workbook_Open, _Activate, _SheetCalculate, _SheetChange, _SheetSelectionChange and Worksheet event macros such as Worksheet_Activate, _Change and _FollowHyperlink. These work great except occasionally and very intermittently and...

I have 3 workbooks, one of them (wb1) has a vba code that copies some formuled cells (a1:c23) in a worksheet from wb2 and copies them in a worksheet in wb3. The thing is that the formulas copied in wb3 are referencing the wb2 instead of wb3, how to copy without this reference?

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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