automatic

With VBA how to run excel formula in a range a1:x100 without changing any value with automatic update and error.

Hi all I have a training spreadsheet and want to send an automatic email to a manager when a cell D9 changes to "Retrain" in the column D "Status" Cell C9 holds the managers email address manager@email.com I need the following in the email: email address of the recipient Subject: Training...

Hi all, I'm trying to change the "automatic" font colour to my company standard colour in Excel 2016. It seems it used to be possible to set this colour in Windows "Personalise" in previous versions of Windows, but Windows 10 works differently and doesn't allow this any more. VBA seems to think...

I have a very large workbook that i need to have open all the time, but I need it to be in manual or else excel/my computer is too slow. During the day I open other workbooks that are normal-sized, and it's annoying that they can never be automatic. Is there a way to have one workbook that is...

Problem is the code works to drop the copied data into the right tab, but the calculation of the data afterward does not work. https://www.dropbox.com/s/py3oajhri3162n2/Sample%20Analysis%20Template%2805Nov2018%29_DB.xlsm?dl=0 Can anyone tell me what I am missing? I have tried manual and...

When I "Paste as Value". I would like to have the text automatically replace itself to something new in the same cell. IE: "POS DEBIT - MCDONALDS" --> *Paste into cell* --> "MCDONALDS". I cannot seem to find a function to fit this once I paste it. Is there a VBA script to help? I will...

Hello, Do you know if we can add automatic date list to the userform via macro code? Thanks Khalid

Hey, I have an excel file with a lot of document numbers, and those numbers are corresponding to documents in a map on onedrive. Is it possible to create a vba so excel will search to the corresponding documents in onedrive and create automatic hyperlinks? So if I add numbers to the excel file...

Good night, I started interning in an office where my boss asked me the following: "I'm going pass to you the sales KPIs, for you automate the dashboards generation" From what I understand ... the office uses a website to generate various reports in "Excel Binary Sheets". My boss takes...

I have a file on our One Drive, is there a way I can receive an automatic email when that spreadsheet is modified? Thank you,

Need to create 350 sheets based on data in column J

Hi!, I am trying to show/illustrate a connection between cell A1 and B3,B4,B5 through an automatic arrow / line - not by using shapes. Any help appreciated! Thanks! G

Hi All, I have a spreadsheet with a formula I tried dragging down, and even though it copies the formula correctly, the results remain the same in the entire column. I tried F9 / checking formula settings were set to automatic but that did not sort the problem either. Anyone able to help? Thanks!

Hi All, for sheet1, I have placed code that on active sheet password msg will prompt. Here, Im creating sheet1 copy and renaming with the user name who is logged in. Therefore, in the red colored code, it asking me input box (2 time) to place password, and we dont want to share password with...

Hi Guys, I am looking for a way to open a folder, and have different workbooks open different files, using a partial title and then run specific programs. For workbook1 I have this code: Sub Foo() Dim vFile As Variant Dim wbCopyTo As Workbook Dim wsCopyTo As Worksheet Dim wbCopyFrom As...

Hello, I have column AA & AC where some values shall be changed. How to make automatic macro after values changing in some cell AA and AC or vice verse? I have macro automatically run when values is a change in one cell. I need macro where running will start after the value changing in the...

Hello, I am trying to extract abbreviations from a string of words and display them in a new cell. The abbreviations are as follows: Wheat; W Dairy; D Egg; E Fish; F Shellfish; SH Soy; S Peanut; P Tree Nut; TN Vegan; VGN Vegetarian; V The Strings can be any combination of any or all of these...

I'm starting to learn VBA but am not able to write this myself yet (aka I'm just starting to learn but have a working knowledge of SQL so I can interpret some but can't write it myself yet). I want to create automatic follow up reminders for myself for when I need to call someone back. I have...

I have a dropdown list in excel. is there anyway that when i select a value from dropdown list cursor should automatic go 1 cell down automatically. (actually i m using this file in android phone. i want a macro free solution). i want that when i tap on a value in dropdown it should put that...

Hi All, I currently have a worksheet called “Summary.” It has values in columns A to J. I want to add borders to every single cell that has data in it (in that worksheet only). No data, no border. Etc. I’m already running several macros in the entire workbook so conditional formatting will not...