jyggalag

  1. Jyggalag

    How to use Vlookup with IF statement?

    Hi all, I am very rusty in Vlookup (embarassing!) and I am currently looking at this data: I would like to create a formula that checks the same date in column A, as checked in column F and then tells me whether or not the value for this date is also present in my data set in columns F-G. I...
  2. Jyggalag

    Format data as Day-Month-Year instead of Month-Day-year

    Hi all, I currently have a data set that looks like this: The issue for me is that it is currently stated in a format of "Month-Date-Year". I would like to replace this with a format of "Date-Month-Year". Does anybody have a nice solution to this, for example a formula as illustrated in my...
  3. Jyggalag

    Create slicer for a list without pivot table?

    Hi all, I currently have a list that looks like this (albeit much much much larger in reality): I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...
  4. Jyggalag

    Change my VBA code so it sends pdf file instead of excel file

    Hi all, I currently have this VBA code: Option Explicit Private Const FilePath As String = "S:\COMPANY\FOLDER OF COMPANY\FOLDER 15\TEST FOLDER\Attachments\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim col As...
  5. Jyggalag

    Merge multiple email cells into one cell?

    Hi all, I currently have this setup: My VBA code is this ( credits to @RoryA :) ) Option Explicit Private Const FilePath As String = "\\UBSPROD.MSAD.UBS.NET\userdata\t684895\home\Documents\faq folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i...
  6. Jyggalag

    VBA email macro converts text into numbers?

    Hi all, I have this amazing email macro that @RoryA helped me build (big credits!). He created a nice loop for me that runs all subjects in an email meaning I can email as many email addresses as I want at a time. However, when I run it now, it converts my text into numbers for some reason...
  7. Jyggalag

    Email macro

    Hi all, I currently have this code: Option Explicit Private Const FilePath As String = "\\COMPANY.MTJG.COMPANY.NET\userdata\t6853532895\home\Documents\TEST folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim...
  8. Jyggalag

    Use macro to delete files from folder?

    Hi all, I currently have a data overview that draws data through power query from a folder in my windows computer: However, I plan to update this folder rapidly every week and I was wondering if it would be possible to create two macros attached to VBA codes, where they do the following: 1)...
  9. Jyggalag

    Conditional formatting based on color?

    Hi all, I have this file: How do I make a conditional formatting formula (or whatever it takes) so if the COLOR (not the text!), but the color in column C is red, then the color for the respective cell ("hello" and "this" in cell A1 and A3) will also turn red? Hope my question makes sense...
  10. Jyggalag

    Create macro that copy paste's data

    Hi all, I am having a huge issue at the moment with some macros i created (through record macro). Basically, I have this excel sheet: I tried to record some macro's, where once I press unfreeze, they post this formula: =IF(ISBLANK(B9),"",TODAY()) for the left one...
  11. Jyggalag

    Weird power point formatting removing borders?

    Hi all, I am currently facing a weird issue in PowerPoint. When I type text, the border disappears underneath it: It is specifically happening in the cell where it says "test" in bold. Any idea why this is happening? I've looked at my formatting, but cant quite figure out why. Kind...
  12. Jyggalag

    Save file as PDF in VBA (macro)?

    Hi all, I currently have the following setup: I have marked everything that I want to be exported into a PDF, which works when I manually save the file as a PDF. However, I do also have a macro ("Save file to folder") as seen above, which saves the file (albeit as an Excel file) to my...
  13. Jyggalag

    Make Power Query (insert data from folder) files delete or ignore first row

    Hi all, I currently have a bunch of files that are 99% similar, except they have some different data in their columns. The first two rows will always look like this: Unfortunately, the first row messes with the power query, so it returns this: If I remove the first row, my file works such...
  14. Jyggalag

    Two different colors in a cell?

    Hi all, I currently have the following table: Is it possible to make it so cell A3 has the same color fill as cell A2 (light blue) until it reaches "Week:" where it would then have a yellow fill? Thank you! :)
  15. Jyggalag

    Freeze =Today() formula once data has been entered

    Hi all, I am currently using this formula: With its neighbor formula in column C going like this: My question is whether it would be possible to somehow freeze my data in cell B3, C3 etc. going forward? So once the formula detects that a data entry has been in the cell 2 rows below it, it...
  16. Jyggalag

    Conditional formatting for blank cells containing formulas?

    Hi all, I currently have this setup: I have a row of formulas saying IF(ISBLANK(cell below),return blank value, otherwise return value to the left + 7) to advance the week one week ahead when data is entered. I want to create a conditional formatting for this row, so whenever a value is...
  17. Jyggalag

    How to remove borders in PowerPoint without merging cells?

    Hi all, I have a table that looks like this: Whenever I try to remove the borders, I am left with 2 possibilities: Either the border is removed and I am left with a white border (rather than a full green box) where the old border was, or (most common) the cells are merged into one big green...
  18. Jyggalag

    Make macro that saves a file

    Hi all, I would like to create a macro where, once I press it, it saves my file to my folder \\COMPANY.MDDD.COMPANY.NET\userdata\t654895\home\Documents\test files Does anybody know how I would go about in doing this? :) Thank you! BR. Jyggalag Prince of Order est. March 26, 2007.
  19. Jyggalag

    IFBLANK formula but with specific text as well

    Hi all! I have this formula: But for some reason, my formula does not work? I want my formula to return "NOT BLANK AND NOT 1" if the cell contains a value that is not = 1 and not a blank cell. If the cell contains the value 1 or is blank, i want my formula to return a blank cell. Can...
  20. Jyggalag

    Pivot Table with Query

    Hi All, I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one. In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...

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