automatic

Have any of you ever used an add in such as AutoMacro to assist in generating VBA code for macros? I'm a beginner, but I've been learning and researching through many different forums (like this one- thank you!) as well as youtube videos and whatnot. But as you know, the macro recorder doesn't...

I have a specific code structure that I would like to be automatically generated based off of text from other columns in the same row. The code Structure is: XX.XXXX.XXXX (PROCESS AREA . COMPONENT/DISCIPLINE . ITEM) The first two digits are meant to represent an "Area" (##.XXXX.XXXX) The next...

Hello good people of MrExcel, I need a way for Excel to automatically create a comment "Comment Generated on (Today's date)" in a specific field, let's say "Q9", when the date in field "U9" is -180 days or more from today's date or rather when 180 days or more have passed. I have been searching...

Hello Everybody. I'm struggling with an automatic login. div id="userid01" input type="text" name="USER" tabindex="1" div id="password01" input type="password" autocomplete="off" name="PASSWORD" tabindex="2" The most classic of my numerous attempt is the following...

Hello Gurus, I am currently trying to break oneline summaries into many rows. Basically, on one tab, I have one line for each subject. This line says how many events that subject had. I want to have another tab that creates rows for each subject and event. The desired look is below, I just...

I really need help. I need to put together a spreadsheet for my boss. I do not know VBA (at all - someone helped with the macro below) I have several issues. 1. Using the formula below in the Master sheet, I need to bold the name of the sites (Big Spring, Dubois, etc) when it returns a...

i have an excel file in "c:/desktop/files" where, by inputting a unique customer code, an one-page report is produced with all customer's data. What i need, is: 1. my colleagues to be able to send an empty e-mail, via outlook 2007, with only the customer code in the subject line 2. the excel...

hello once again and i wanna thank you for the help iam getting in here most helpful forum i found so far i wanna us (IF) function in input a text based on a certain value i have 60 accounts in my program and i want when i make a transaction from cell to another it get written automatic on a...

Hello, I have a spreadsheet using 2 data series, both have formulas. I would like to know if there is a option to turn on auto-formula calculation for one but not for the other. Would not mind any solution for this (formatting, VBA, new formulas, help columns, anything). Any help would be...

I have a SQL query that updates through Excel (Data > New Query > From Database > From SQL Server Database) and I have some columns with formulas added. When I refresh the query, new rows are added and my formulas don't fill down automatically. I have to drag them down to get the formulas to...

Hi! I'm new to VBA, and I've been trying to find how to send an automatic e-mail from Excel whenever someone updates the file in Column Q to "YES". In the column, there are 3 options: YES, NO, or N/A. There are hundreds of rows so hundreds of previous Yes, No, and N/A. I only want the e-mail...

Hello there, I require in Column R & S only in “DataInput” sheet, when I wrote in cell. w then automatic comes Winner & l for Looser. Require VBA coding. Regards, Rahul

Hello, I am looking for some help creating VBA code that will transfer expired rows from the first worksheet - called "Valid Clearances" - to the second worksheet - called "Expired Clearances" I initially troubleshooted this issue via google, but the codes I found never worked when I tried to...

Hello, I recently wrote a simple Macro to calculate something using a for-loop. The Macro works fine, except that Excel crashes every time at the end. After some researching I found that the probem lies with re-activating the Automatic Calculation (which I set on 'manual' at the beginning of...

Hi! I'm banging my head with the timesheet but heading nowhere; if anyone can help me out that would be highly appreciated. Here what I'm trying to do. I have two time Actual Time and Adjusted Time I'm trying to create an automatic system using if or any other formula where I could get the...

Hello There! I'm looking for a solution to my problem and have not found anything online, so I'm coming to you. So, this is what I'm looking for: The barcode scanner I have is a keyboard type and works well with Excel, but... 1. When scanning a barcode, I want ActiveSheet to...

Hi, As I have used over 7 Slicers and at a STRETCH I NEED TO REMOVE ALL FILTER. Can anyone help me with the data..

I want to provide for automatic updating of values between two independent workbooks. Workbook A contains several price quotes. I’ve copied those quotes, using Paste Special/Paste Link into Workbook B. However, when I change the values in Workbook A, the new values are not automatically...

I am working on one workbook where 10 different people are responsible for collection, the issue is that i want to have a macro which would send automatic mail to them after the due date automatically. kindly help

Hi All, Is there anyway to apply a macro on a [Shared] file? I would like to apply an automatic save and adjust the track changes features. Thanks, Pinaceous