excel

Hi Everyone, I'm not trying to do anything 2 complex - just compare 2 dates (due date, last completed date), and highlight everything that is equal to or overdue for calibration. I'm using the formula =AND(isnumber($K2),IsNumber($L2),$L2<=$K2 Unfortunately, its highlighting the cell ABOVE the...

I have an Excel Sheet that holds a Table (Table named "PST_2" ) that I need to append to an Access Database (DB named "STATS.accdb"). I need to do this while the user has Excel open, and without opening the Access application, as some users may not have it. I know how to initiate appending...

I have a worksheet with a long Vba code to run many rules in the sheet - One of these rules is to insert today() date in cell "D11" when any edit happen in cells ("E5 or G5")- the problem is that I face a lot of delay in this rule to apply after many times try and sometimes it run after...

Sub WO_SaveUpdate() Dim WORow As Long, WOCol As Long Dim AssignedTo As String, SharedFolder As String, FileName As String, FilePath As String ActiveWorkbook.Save Application.ScreenUpdating = False With Sheet1 If .Range("D4").Value = Empty Or .Range("H4").Value = Empty Or...

Hi, Working an a budget template. And i want to make a formula that splites the amount into the correct months based on dates. Currently i have following that works if the two dates are in 2025. but marked line with end date in 2026 is giving me problems. Should give me 50.000 from july to...

Hi Not sure what I doing wrong, I am trying to calculate time in several cell to give me a total, however I keep giving me the wrong figure and I can not work it out. See example images below. The total does not add up. Example 1 Time is in hh:mm Example 2 In this example I have change...

Hello all, I think this topic has been discussed in many posts here and other forums. I'm sorry for the Clickbait (for some), however, I was unable to solve my problem.... I have a workbook to register my expenses, so I have a Sheet for every month of the year: so, first sheet is for January...

I currently have the sub-Macro below which filters for Columns A and B (for Strings Asset and SN), and then copies the value. What I'm trying to figure out is how do I set it so that if no results are found for either, the macro would generate an error instead of crashing/copying just the title...

I am trying to add trend arrows to my data based on the previous month. Please see the examples table below. Let's say we're looking at the data of orange crates sold each month for the last six months. January- 16, February- 6, March- 7, April- 4. May- 18 and June- 47. How would I get arrows to...

I have a code in excel sheet to save the currant page as pdf into pc folder based on cell value + current month text and it's working perfectly with just one problem - when I have an old file already saved in the folder and I need to save a new one with the same month name, the new file...

I created a UserForm that stores 15 fields into a worksheet. This UserForm has functions like opens a ListBox with all the records, filter the records, edit the records, etc. When I run the UserForm everything is fine and it runs smoothly. But I'm having a problem that when my coworkers try to...

I have a Word template that is used by various contributors to submit articles. At the bottom of the template, I have document fields that calculate the total number of pages and words (as separate document fields). I need to know how to dynamically link these document field results (the...

Hi Good People, Currently I am working on a tool that would extract Reflection Workspace data to an excel file. The proble is, there are multiple pages or screen of a specific screen. Like for example. I managed to copy the first page of the screen, then you have to press page down key inorder...

I have this code that sends a range as a picture into an outlook email. I added checkboxes and want to be able to modify the code to send the contents in range B4:B17 and one or all of C,D, and E depending on if the checkbox is true. I have no idea how to do this, can anyone help me? Sub...

I have the following code that works most of the times, sometimes if gives me this error when using it consecutively too quickly: Run-time error 1004 CopyPucture method of range class failed. But I guess I can live with that :( What I need is to be able to add add text before the picture in the...

I have a spreadsheet with multiple tabs. In the tab titled "Cal/PM", The user will make an entry in Column A, and is supposed trigger the code below: Dim Asset As String Dim spec As String Dim cal As String Dim pm As String Private Sub Worksheet_Change(ByVal Target As Range) ' Check if the...

I have 02 issues with autocpmplete.... first - I have a worksheet with multiple pages (alomst 30 pages) and autocomplete only work in the current page but when I scroll down to insert data in a new page it doesn't work second - another worksheet with a table and I have 4 coulmn where i insert...

Hello All, What could be the formula for total years ( 8 Years, 3 Months) in the below case? Thanks in advance.

' Spot = Spot Price of the underlying ' K = Strike Price ' T = Option Maturity in Years ' rf = Interest Rate in decimal (i.e, for 5%, use 0.05) ' vol = Yearly volatility of the underlying in decimal ' n = Number of time steps ' OpType = 'C' for Call and 'P' for Put ' ExType = 'A' for...

Hi, I need VBA code to get the list of top 10 recently modified files on the excel ribbon as macros in excel ribbon. The list of these files must be obtained from the Sharepoint link.