excel

  1. S

    VBA sending an email of two conditions are met

    I'd be really grateful if some one could help me with this, I've been trying to work it out for a while but I'm not getting anywhere. I have a VBA to send an email based on individual rows and the data they contain. I'd like a way of sending individual emails to all recipients and the data on...
  2. T

    thisworkbook.saved changes inexplicably

    (Note: I have already posted this question in other groups but have not received any response) My goal is to close a file without being prompted to save after changing a shape, specifically the size of a button; to this end, after changing the button, I set Thisworkbook.saved to True but if I...
  3. X

    Power Query Reference vs Duplicate for Performance

    If I have query (1) with multiple steps and I need to have query (2) based on query (1). For performance and/or good practice is it better to: A) duplicate it and then modify and or remove the steps carried over to get what I need or B) is it better to reference it and then create steps to...
  4. Q

    Excel existing code flaw

    Greetings, I have an excel document that tracks items on a "to-do list", I have an active and historical tab. Active for anything that is still outstanding and the historical for anything that has been completed. I am running a code that will automatically transfer my active tasks to my...
  5. R

    Help please - COUNTA error

    Hi everyone. I'm currently building a new order form for work and I've been asked to have one of the tabs auto-concatenate certain information from three other tabs - to prevent the customer from overtyping and getting it wrong. So I have four tabs:- Product A, Product B, Product C and Control...
  6. T

    If Formula

    Hi, In cell R66 I am trying to return a blank cell if the J66 is also blank. I currently have the following formula: =IF(S66="No",J66,"Reference"&"_"&J66&Q66) In cell R66 I have "Reference" and would like this to be blank. Can anyone assist?
  7. M

    New Excel Saving Progress Bar?

    I have a few users who are reporting some type of "new" saving progress bar that comes up in Excel. It comes up in the middle of the screen, stays for maybe 30 or so seconds and goes away versus the normal saving progress which is at the bottom right in Excel. It does save the document but due...
  8. FatalLordes

    Clear a cell when select ANY option from drop down?

    Morning all (well, it is morning here). So I'm using O365 and I'm wondering if there is any way to have excel clear a cell (lets say D16) when you make ANY selection from a drop down box located in another cell? And continuing on from that, as well as clearing a cell so that it contains...
  9. S

    conditional formatting error

    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...
  10. M

    Excel Table - How to Append to Access Database Using VBA

    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...
  11. Ramadan

    How to fix vba delay in runing the date rule

    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...
  12. D

    Can't get folder to create on desktop. When debugging it shows no errors.

    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...
  13. K

    Amounts distributed by months based on two dates.

    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...
  14. Sharid

    Time Not Calculating Correct

    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...
  15. E

    I have 1 UserForm and want to save to different sheets in the same workbook

    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...
  16. S

    Return error if "Filter" doesn't return the required entry

    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...
  17. P

    Adding Trend Arrows

    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...
  18. Ramadan

    Export excel file as PDF into a targeted pc folder based on cell value

    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...
  19. J

    UserForm frozes on other computers

    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...
  20. M

    Dynamic link from Word to Excel...

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top