automatic

I need help creating a countdown from $3,000,000 that auto updates every second to a lower number. I have the macro below that works for updating the sheet every second and it works. But I need the $3,000,000 to drop by $3.94 every second. Any ideas on a simple formula that will allow it to...

Hello, So, with help of kind people here I was able to make most of my project work, but have hit the hopefully last bump. Basically, I have a worksheet that based on condition decides whether the issue should go after Quality, Logistics or Finances, and then generates an email to be just sent...

Hello, First of all, I am still new to VBA and more complex excel coding, so I'm learning by doing, searching forums and tutorials, stitching together bits and pieces of code I need. However, I ran into a dead end and would need help. Basically, what I'm trying to do: I have a project to sort...

Hello All, So basically there are several KPI's where the 'Target' Value can vary on a Month by Month basis. I would like to create several Conditional Formatting scenarios that highlights it as Green, Yellow, Red and Blue based on how close the ACTUAL figures are to said Target. At the moment...

Hi all, I have countless option buttons in a sheet that are always grouped in pairs of two. The option buttons simply pass a value multiplied by the factor from A1 to another cell. Everything works like this... However, when I change the factor in A1, the corresponding value in E231 is not...

Hello all, I'd like to know how to have a table be automatically refreshed based on a filter. The thing is that I have 1 tab, where I paste some data (its a table), and then i have in other tab, another table which is populated taking values of specific columns from first mentioned table. And...

I have an excel worksheet that when I run the code, it enters the cell data based on the number I place in Column 1 or item column. In order to retrieve the data, I have to run the code using a macro-assigned button. My objective is to have the data populated in Columns 2 and 3 automatically...

Good Afternoon, Hoping for some help here, I clearly don't know what I am doing. Here is the goal: To update my master spread sheet. I am trying to implement a new project tracker, this will be an excel sheet, named exactly the same thing, for EVERY job. It has a table in it on a hidden...

Hey! This forum has been a huge help thus far, and I am coming here again with a potentially tough one. Here's what I would like to do: When a cell says the word "Active" or "Service Active" it sends my coworker an email letting them know to add it to quick books. Here is what it looks...

I have a master file and a Data Folder that contains workbooks with the same format. I also have a VBA code inside the master file that is able to copy the first sheet of all the selected workbook Sub Merge_Files_First_Sheet_Only() 'Merges all files in a folder to a main file...

Good Afternoon, This seems to be a pretty common request, and I have tried other codes in other threads, but none of them are exactly what I am looking for. Heres the Goal: Create a new folder in a particular part of my server (This changes based on the information they put into the...

Hi Members, I want to create about 100 invoices each month using a single button. So my sales are being recorded at a day level in excel. At the end of the month, I want to create the invoice for the sales without much effort. Currently, my team copies the data for each client one by one. Is...

Hey guys, I am new here, and not an excel "expert" whatsoever, so I don't really have much knowledge of the code itself. I currently have a master file that is saved to our company's One Drive. This file contains 8 sheets in the workbook and at maximum goes from column A to column V. At the...

Hello everyone, this is going to take a bit of background to explain the issue in detail. I've been working on this project for so long I'm going cross-eyed. It wouldn't surprise me if there's obvious problems that I can't see because my nose is too close to it - y'know? Anyway. The purpose...

Hello everyone! I'm trying to make a sheet for an automatic sales follow up. I've integrate the systems with PQ, but the problem is : We have the sales order.csv where is refreshed every day, and I need to do an analysis with the Purchase Requests and Inventory. The logic basically is : If the...

Hi all, I currently have an automatic code that can open up the MOST recent (date modified) file in a folder. It works great BUT my concern is: Lets say i set a timer of 10 mins to execute this macro, However the macro takes 15 mins to run and inside that space of 15 mins another 2 files are...

Hello everybody, Whenever I open a PowerPoint document, the function "Embed fonts in the file" is turned off: Is there any way in which I can make it so this is automatically turned on? Thank you! :) Best regards, Jyggalag

Hello, I am currently trying to send automatic emails in an excel workbook, but every time an email is sent, since my company is subject to TITUS classification, I have to manually select it in a pop up. I use a regular outlook protocol to send emails I have not been able to find anything to...

Hello, I am looking to have a macro ran periodically on a spreadsheet. In order to achieve such a goal, I based myself on a post I saw from The Spreadsheet Guru (link below)...

This is a continuation of a post that is now buried. Application.OnTime continuously opening my workbook The Code @AlphaFrog helped with is working perfectly. Each instance of save, the workbook comes to the foreground and then to the background again after the save is completed. While this is...