macro - auto run

I recorded a Macro, to get this, but the record can't actually work with returning the value and going to the next row on it's own. I'd really appreciate any help. If this can be done with a Formula or VBA macro, i'd greatly appreciate, thanks. Sub MacroTest () ' ' MacroTest Macro ' 'fileX...

I piece together weekly reports for my team. I keep row heights at a minimum 75.00, 100 pixels and maximum 203.25, 271 pixels. To take a lot of time out of this task and make it automated, I would like to conditionally format (though probably not possible based on my research) or enter a code /...

Hello! I have prepared a document in which about 50 volunteers must indicate their availability on certain dates each month. The columns in which they indicate yes or no should always open for editing, for anyone. In contrast, columns A through L contain information they should never be able...

I am trying to get the script/macro to move my selectee from onboarding table to completed table. 437&438-Onboarding table column y= "Move to Completed" is a drop down and is blank until "YES" is selected from the drop down. (that is the only option) Station Selectee Effective Date Position...

I am a beginner trying to maintain my business data using Excel. I created a macro that copies the information from a sales info table and pastes it into an adjacent table that records the customer's name, items bought, total sales, etc. But when I rerun it the next row is not being used and it...

Hi! I'm a complete begginer, so i don't know much about coding. I'm trying to create a button to run a macro that does the following: 1.- Save sheet2 in a specific location as PDF and saves the hyperlink in sheet24 of the active workbook in column 11 2.- Save a copy of some of the sheets of the...

Hello everyone I have a problem. I'm trying to run a macro but it doesn't work. When my co-worker runs it, it works perfectly. We both checked the settings in our computers and we have the same enable so I don't know what is the problem I would really appreciate if someone can guide me Best...

Hi all, I am a completely new user to Excel Macros! I have sourced myself a code from this site, that goes a little something like: Private Sub Worksheet_Activate() Dim LookupRange As Range Dim MoveToRange As Range Dim MoveDay As Long Dim ClearRow As Range Set LookupRange =...

macro

Hi everyone! I'd like to seek your expertise here as I am new to macros/VBA. I have 5 workbooks, and within each workbook, I have a number of worksheets. However, from these worksheets, I'd only require about two to four columns of data to be copied (these could be 1 - 2, 3 - 4, or, 1, 3-4, 5...

Hi all, hope you are doing. I'd like to ask if someone can guide me how to build a macro that updates automatically xml tables? I have already recorded a macro to map the xml however when i try to record an update or import the files it gives me an error. It might be simple but can't find a...

Hi All I would really appreciate your help. I would like to create a manager workbook for individual managers which include different tabs for appraisals, training and sickness of lists of there staff. Currently I have managed to pull the different reports for all and complete a macro to...

Sub Macro1() ' ' Macro1 Macro ' ' SolverOk SetCell:="$BD$8", MaxMinVal:=3, ValueOf:=0, ByChange:="$AJ$8", Engine _ :=1, EngineDesc:="GRG Nonlinear""" SolverOk SetCell:="$BD$8", MaxMinVal:=3, ValueOf:=0, ByChange:="$AJ$8", Engine _ :=1, EngineDesc:="GRG Nonlinear"""...

Hi, I need help please! I have this code but I need it to work automatically. The idea is= I need to gain the data from the range "A6:W29" but only cells with data and to do it in every sheet except for "RESUMEN" "S.Inicial" and "S.Final". Right now I can merge all the info but running the...

I have 2 sheets in my excel file (Data and DataRanges). DataRanges sheet includes Start & End columns (multiple rows) which represent the range for each graph. The data sheet includes Data Serial which will represent data in serial for those ranges (start, end) to plot a simple line graph...

Hi, I'm trying to make a macro run on every sheet in my workbook, problem is macro doesn't work if cell value is 0: Sub Ola() Dim Rng As Range Dim InputRng As Range, OutRng As Range xTitleId = "KutoolsforExcel" Set InputRng = Application.Selection Set InputRng =...

how do I add a Macro that will work with multiple CSV files of the same name. but only search the one thats in the same(file) location. as the spreadsheet using the macro normally you could use .\ to reference the same folder, but this doesnt work. any help would be great My spreadsheet...

I'm using Office 365 and am importing data from an external database, creating a query as I do. I then have a macro that does some formatting and copies the table, without headers, to my main table. The code works perfectly if I open the editor and run it line by line. When I create a button to...

Hi Everyone, I need you help regarding with my problem. I don't know how to do it. I have 3 files, 1. Result 2. Files 3. Score On the result worksheets, I have a list of vendor including the path of each worksheets( Score and Files). What I want to happen is to find the latest date on...

Note: I'm too basic in VBA/macros... I have a macro that exports my sheet as CSV without leaving the XLSM file, that works great: Sub ExportCSV() Dim MyFileName As String Dim CurrentWB As Workbook, TempWB As Workbook Set CurrentWB = ActiveWorkbook...