yonasreppenk

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

Hi all, I currently have an email macro in VBA that looks like this (important parts only): Basically, I click on a macro and it sends out an email to the emails listed in certain cells. However, the message that the email depicts has been written in VBA with the .HTMLBody code. Does...

Hi all, I have the following formula: It checks if the cell in C9 is blank (which it is not, the text is just hidden) and then returns the current date of today. However, I am also referring to cell C7 in another cell, specifically like this: My issue is, obviously, that the cell...

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

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

Hi all, I have my folder here: Anybody got any idea how I can expand the files names that end with "file name 1...", "file name 2..." etc.? So I can see the full name would be nice if there was an easy solution that did it aggregately as well thank you all!! :)

hi all, if I have two shapes next to each other that I have attached macros to and I want to align them horizontally, so they don't look silly, how would I do this without manually moving them around forever? thanks! Kind regards, Jyggalag

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

Hi all, I have this diagram: However, the "above average", "average", "below average" etc. are really filling up a huge portion of the pie chart. Can somebody please assist me in how I can hide them without removing them? Thanks!

Hi all, I have this data sheet: I have turned it into percentages and I assume that the top value (0.36% & -1.52%) are the sums of my columns (I am very new to Pivot, sorry). But I have #DIV/0! errors! :( Is there a way in which I can implement an IFERROR formula for my entire pivot table...

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

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

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

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

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

Hi all, I currently have a sheet that looks like this: (Please note that I have divided my excel file into two windows, so you can see both sheets at the same time). I have created a pivot table (very new to this!) in Sheet2 where I can store the data. I expect, from now on, to download my...