1. Jyggalag

    Iferror(Index&Match&Match) formula

    Hi all! I currently have a large worksheet that is similar to this: With the master data looking like this: I want to create a sort of IFERROR(IF(INDEX=0, ,MATCH and MATCH formula (with an iferror that returns "" (blank) if there's an error)) for every column with [] such as [DATE]. So...
  2. K

    Can someone tell me how to leave the number with only 4 decimal places?

    The "error": The code: Dim oPL As Double, o709 As Double, o710 As Double, o713 As Double Application.ScreenUpdating = False Sheets("Calculation_Sheet").Visible = True ActiveWorkbook.Sheets("calculation_sheet").Activate Note: P666, P709, P710 and P713 are global variables...
  3. K

    Can anyone tell me why is this appening?

    Private Sub UserForm_Initialize() Call CallTime_Msg lb_hello.Caption = msg lb_tec.Caption = Tec End Sub Sub CallTime_Msg() Dim mHour As Integer Dim msg As String mHour = hour(Now) If mHour < 12 Then msg = "Good Morning" ElseIf mHour < 18 Then msg = "Good Afternoon" Else msg =...
  4. E

    Debug after running macro

    I have a macro that I have assigned to a button which looks at a certain range of cells formatting, and upon clicking on the button, it copies the cell formatting of the range, and copies it to another range on the same page and also other cell selections on another sheet. I also have some VBA...
  5. K

    Error trying to select sheet with public variable

    I am trying to make a code that makes the program write data in a specific excel spreadsheet according to the value of the variable "MachineName" declared as public What happens is that the program does not allow me to do it because an error is detected on line 96 The error: The code...
  6. Jyggalag

    IndexMatch function not working, please help :)

    Hello everybody, I currently have something similar to this: Linking to this: It should return the date 21-06-2019 for XG10, but it does not. Can anybody see what I did wrong and how to fix it? Would be greatly appreciated! :) Thank you! Best regards, Jyggalag
  7. Jyggalag

    Change order when pulling cells horizontally or vertically

    Hey guys, I currently have a large list of data, but to simplify, here's a simple example: I currently wrote cell C5 as = J5 I then pulled it through the green box as you see in the photo to the right and got A, B, C, D and E and pulled it down and got 1, 2, 3, 4, 5 However, I want it to...
  8. R

    Archive Rows Code Help

    Hello! I am updating a document for work and which shows projects being worked on and their status. I would like rows which have been marked as "Archive" to be automatically moved onto another worksheet so as not to clog up the current work. How do I input a code to enable that to work...
  9. L

    Userform search

    Hi, I have a table with 45 members and let's say 100 columns. Each column is a date and members will have a negative figure within the cell referencing their name and the date if they have a holiday. (EG John Smith is off on 12th June so he would be -8 in cell H22). I want to be able to...
  10. Jyggalag

    Excel not showing blank in formula when I want it to

    Hi all, I currently have this formula: Right now the cell is showing a blank cell. I then have another cell that links to this cell through this formula: This cell also shows blank, because the first cell is blank. I then have a third and final cell with this formula: However, this...
  11. X

    Macro to enter a value in different tables

    So i have 4 different tables with a set amount of columns each (2 with 2 columns and 2 with 3 columns. all are named differently). The thing is that if i get a new item i need to enter its itemnumber in those 4 tables in the respective row. Is there a way with a macro to fill the cells of my...
  12. A

    MkDir issue in VBA

    Hello all, I have a very simple VBA code, that I use to create a new folder. MkDir "C:\Users\aan\Desktop\" & [A1] I keep trying and failing to make both parts of this a cell reference. I need both the location and new file name to be changeable. Thank you!
  13. Jyggalag

    Embed fonts in the file - PowerPoint (automatic function available?9

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

    VBA code error - its stop on "YES" and highlight with colour

    Hi All, When we use the below code in vba, its stop on "YES" and highlight Range("Y8") = "=IF(N2<F8,"",IF(AND(N2>=F8,N2<=G8),"YES",""))" what is the solution
  15. V

    VBA Code - Copying data from a range to next range

    Hi All, Why the below code is not copying data to till last row Sub copytilllast() LR = Cells(Rows.Count, 1).End(xlUp)(2).Row Range("N2").FormulaR1C1 = "Max" Range("N3").FormulaR1C1 = "Min" Range("O2").FormulaR1C1 = "=MAX(RC[-9]:R[4]C[-9])" Range("O3").FormulaR1C1 =...
  16. S

    COUNT and Copy to Last Row, Paste to another sheet to Last Row (FIRST EMPTY ROW, adding, not replacing value)

    Hey friends. Im New in VBA. Could you help me at this? So, we have 2 columns: AB with data, in Sheet1 I want to COPY until Last Row in AB Column from Sheet1 and paste it to Sheet2, column CD in FIRST EMPTY ROW (i mean while adding more data, cause CD is supposed to have previous data) Can...
  17. M

    Macro to launch a dynamic url in a cell

    I'm very new to Macros and all things excel and have been trying to find the correct code or help for days. I have a few urls that are all dynamically built with the hyperlink formula based on populated data on other sheets. One of my sheets contains all the of website formulas for the...
  18. C

    Moving row to another sheet, with pasting starting in Column B

    Hello, I would like to move rows from one sheet to another, depending on the content in Column Z. The value for go-ahead is "0" (as this means there are 0 blank cells in the row). I have managed to move my completed rows from "Complete" to the next available row in "Archive". This pasting into...
  19. V

    Copy Data From One Workbook To a Specific Workbook

    Hi, We have Two Workbook in same location Workbook Name 1. Test 2. Data now we want to copy data from Test, Sheet1!A2:A and paste in Data, Sheet1!A2:A and we want to copy data of Test, Sheet1!B2:B and paste in Data, Sheet1!C2:C advice pls
  20. V

    Vba for making a calculation based on condition

    Hi, we have a large data where we want to get some result, we have formula but want to convert it to in vba Our Steps are 1. First time we are checking the value in T column if we have got the value then second step 2. We have got the value in T8, now we have put the formula...

Watch MrExcel Video

This Week's Hot Topics

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