#macro

I need to run a excel table that dynamically changes based on form control drop down selection. I want to run a macro that changes the dropdown and copy+paste my table else where for all values in the form control. Can someone please help ? from the pic: based on brand selection, the table...

Hello, I am trying to track some testing specimens at work, and I would like to have to automatically populate a date when the status drop down menu is changed. For example, I have a status column located in column G. The status has a drop down menu including Not Received, Specimens Received...

Buen día, quisiera saber si es posible compartir una macro de windows a mac, estoy realizando mis residencias y mi supervisora cuenta con una computadora Mac, y mi computadora es windows, al momento de querer ella ejecutar la macro, le aparece un error: error 53, archivo no encontrado...

Buen día, requiero de su ayuda para encontrar la solución a una macro. Estoy queriendo crear una macro que me copie y pegue los datos de una fila en específico condicionada. Es decir, es una base de datos de empleados que cuenta con cierto estatus respecto a si se ha realizado su pago de...

I have a main folder on my desktop, lets call it 'C:\Users\Desktop\Update'. Within that folder I have 3 additional folder lets call them 'FY21', 'FY22' and 'FY23'. Within each of those subfolders there are 5 XLSX files. I have created a code for each file based on the subfolder they are in. I am...

I am using a record of an Excel Macro for a Goal Seek function on Excel. The problem is that when I try to add a new row in my sheet (both above the cells running the Goal Seek or even in the middle of them), the Macro that i recorded cannot be used anymore and I need to record it again (the...

Hello, I have a Macro that runs a solver when called. My requirement is to call the macro multiple times so that we can run the solver for particular number of times. But after executing the VBA code to run the solver, the code runs for 4 to 5 times but then throws this error : "...

Dear community, Context: I am currently working on some macros that should do the following : 1. Open a (raw data file -.csv) as a new sheet in my .xlsm workbook -> Done 2. Refresh 9 pivots based on the file uploaded with point 1 (update data source of all pivots). The current setup is one...

I have a code that loops through all the outlook emails under a subfolder and extract the body of the email based on the subject. How do I modify the code to only append the data extracted from emails in the existing file instead of looping through all the emails and overwriting again & again...

Hi. I keep getting an error as Invalid Next control variable reference for my below code. Any help would be greatly appreciated. Option Explicit Sub ImportTable() Cells.Clear Dim OLApp As Outlook.Application Set OLApp = New Outlook.Application Dim ONS As Outlook.Namespace Set ONS =...

Hi, I have been trying to update the color of corresponding tabs when the table column containing the status is changed. I have written the following code to achieve the same: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Not Intersect(Target, Range("D:D"))...

Hi, I'm trying to learn a bit more about conditional statements in macros. Can you help me adjust my VBA code based on a condition in a different sheet? On sheet2, I have the following data on which I am running a macro (see code below screenshot) Sub MyMacro() Dim n As Long Dim lc...

I am working with a database and right now I am manually inputting the name along with a specific number value. However some names have multiple number values that are different, right now I am having it where if the person has multiple number values I am placing them in a different row. This is...

I’m trying to open Prophet tables (.fac format), update them on excel and then save them in .fac format such that they can be used on Prophet using a Macro. Please help me out as to how this can be done?

Hello, I'm trying to automate a Boolean process on Excel and was hoping to get some help with the loop/vba logic. Column A contains integers that range between 1-4. I would like to create 4 columns on the side (since "A" contains 4 possible values) which have the following logic: If...

(NEED THIS CONDITION) C2= "20 ft" use 5,00,000 C2= "40 ft" use 10,00,000 Change value According "20 ft" Or "40 ft " ------------------------------Kindly Suggest Right Formula-----------------

Hello guys! I want to write a macro to receive data from the 'Transaction' sheet and gives me an 'Inventory' sheet but I don't know how to do it (the 'Transaction' sheet may contain many shares so the macro should count them all and if we sell a share that we don't have in the first...

Hello everyone! :) I need to develop a macro that sums cases and packs (units) quantities from an exported file. The final document has the below aspect: Cases Units Week Cases dispatched Cases forecasted Cases ordered Units despatched Units forecasted Units ordered 35 7517 7794...

Hello Mr. Excel gang, I have spent 10 hours trying and trying my hand at this code. It seems like a repetitive question after scouring the web yet any code I came across gave me some kind of issue, even with hours of tinkering. That being said - SOS >I have hundreds of files in a folder on my...

Hello everyone! I am intending to hide specific columns such as column B,E,G. Also, to unhide it again if its hidden. So my intention is to create a button that when pressed, it first hides those specific columns, and if i were to press it again, it will unhide those hidden columns, and vice...