vba

Hi all, I am new to macros and have been trying to maintain our department's macros that were built by someone who is no longer with the company. The macros are used to pull store data such as address, city, general ledger information and other data. I tried to make some changes to add some...

Hi all I've been looking for threads that could help but haven't found any that I've been able to use. My problem is that I have a workbook with multiple sheets, each sheet has formulas to get info from 2 other sheets in the workbook. I need to copy each sheet (except for the two with the info)...

Hello everyone, I have a lit of parts with part numbers in row b. Some numbers are only numeric and some part numbers start with "a-" (ex. 23443555, 3465787 ,A-10123 ,A-202454, etc.). I need to sort them by ascending order but have the parts starting with "a" on the top of the list. I can get...

Hi Experts Got stuck up at a place I'm using following function in VBA to get amounts in last 2 hours x9 = Evaluate("SUMIFS(Visits[Fees],Visits[VDt],TODAY(),Visits[VTm],">="&NOW()-TODAY()-(2/24))") The challenge is when VBA runs, it automatically adds space(s) before and after ">=" as " >= "...

How do I get a macro to keep the absolute reference of active cells for use in a cell formula later? i.e. I have cell E11 selected, I want my macro to remember the value in cell E11 and the reference, then move to column A in the same row and make a formula that is = 18 - E11 (which should...

I'm brand new to VBA and Macros, having had the luxury of relying on statistical programming languages like R and Python up until now. Due to some restrictions at my workplace that won't allow me to use R Shiny or Python Flask for the task at hand, I am looking to make what is effectively a...

So, I have 156 account numbers with 17 digits. The only numbers that matter on the account number are the last four digits. I need to take the balance of each number and sum them together based on the last four digits or a range of the last four digits. For instance, say I have 12 0000 0000 000...

Hello helpful peeps! I have a massive macro that is run every month on files that are received from an outside source. It worked last month, but this month I received an error. The file received has not changed, nor has the code. I don't get it. Any help is appreciated! The line where the...

Hello, Each week, my whole company attends a meeting. Before each meeting, an email is sent out with a Microsoft Forms link which the whole company must complete to state they've acknowledged and understand the briefing. This is because some employees who work nights can't attend a daytime...

https://drive.google.com/file/d/15bM1T31K9eEbvtOL64D2i63pQ_60Zjtf/view?usp=drive_link I have an excel that calculates business position for 481 branch locations. There are certain number of branches under each Regional Office (RO/RO Name). User can select the branch by entering the DP Code of...

Good morning community, I am retrieving seven values from a saved Invoice to a different Workbook. I have seven rows, from an invoice, to retrieve the values to columns Q to W in a different workbook. My paths start on row three as follows (not the complete path but the important elements are...

Hello, so I want the following thing to add to this (I am very new to VBA and learning this since last friday): - Send Mail from a specific Mail adress (emailItem.To does not work here) - Have a Signature automatically drafted e.g. when I click the Checkmark the Mail Editor opens but my...

Hi, I'm hoping someone can help me. I apologise in advance as it might take me a bit to explain what I need. I'm trying to dynamically/automatically add new rows underneath the existing row that contains a FILTER formula that is working across multiple sheets. I will try my best to explain...

I have a table with 3 columns, whose fields I show below: ABCDE123Customer_IDProcess_NumberFolder_Name41234P0000000011234 - 155678P0000000025678 - 267D4:D5D4=[@[Customer_ID]]&" - "&[@[Process_Number]] The [Process_Number] Column, has the Format...

Please help to modify this code to include the following command, if column H:H in ws.Neonpay is equal to "B" print to PDF a list of the lines in column A:A in wsNeonpay that correspond to the cells in column H:H that are equal to "B" for each of the merchants in the merchant list and if column...

Please help to modify this code to include the following command, if column H:H in ws.Neonpay is equal to "B" print to PDF a list of the lines in column A:A in wsNeonpay that correspond to the cells in column H:H that are equal to "B" for each of the merchants in the merchant list and if column...

I"m running a MacBook Air M1 OS 14.1. I'm running MS VBA 7.1 I'm using Excel for Mac Ver. 16.7 Office Home & Business. The issue I have is when I run a macro when the sheet is protected it will crash. When the sheet does not protect it the macro works fine. I protect the worksheet and I don't...

Hello all, Been an avid follower the recent months looking to create a tracking sheet that delineates to the right after each ending week passes. The tracker has been made and now wanting to introduce a module with the intent to automate the the storing of tracked data. The code I'm looking...

Dear all, I have the below code which uses Dictonary object [CreateObject("Scripting.Dictionary")] to get the unique string name and number of occurrence of the specific string. [ Sub CountUniqueStrings() Dim lastRow As Long Dim dict As Object Dim cell As Range Dim...

Hi, I have a pivot table that was generated by using a power query data model. I have a filter on the pivot table called "EmpName" and I would like to iterate through all the EmpNames in the filter, copy the resulting pivot table data to a new workbook and save it as an entirely new workbook...