fast

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

Hi all! I currently have this setup in Excel: And the code is this: Option Explicit Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t543932\home\Documents\TESTfolder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim...

Hi all, I currently have the following setup: The macro will send out an email to the 1st contact and BCC with this VBA code: Option Explicit Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t865934\home\Documents\TESTfolder\" Sub send_email_complete() Dim OutApp As...

Hi all, I currently have this setup in Excel: Sub send_email_complete() Dim outlookApp As Outlook.Application Dim SendEmailTo As Outlook.MailItem Dim source_file, to_emails, bcc_emails As String Dim i, j As Integer Set outlookApp = New Outlook.Application Set SendEmailTo =...

Hi all, I have the following code for HTMLBody: SendEmailTo.HTMLBody = "Dear all,<br/>" & "<BR>" & _ "bunch of insignificant text bunch of insignificant text bunch of insignificant text bunch of insignificant text bunch of insignificant text ""bunch of insignificant text"" bunch of...

Hi all (please scroll to the bottom for the question), I am currently trying to use the following code to send out word documents through a vba macro (source: Using Excel VBA to Send Emails with Attachments - wellsr.com): In code format: Sub AttachMultipleFilesToEmail() Dim outlookApp As...

Dear all, I am trying to run a macro that sends out emails, however when I try to run it I keep getting this error unfortunately: Can somebody please help me figure out why? I have tried setting source = ThisWorkbook.FullName (takes the current excel file I am typing in as an attachment)...

Hi All, I am having an issue in Excel. My current setup looks like this: However, if I put range("O2") it works fine and it sends out the email to my email address. But once I try to increase the range and make it send out to multiple emails, it comes with the following error (highlighting...

Hi all, I am facing an issue with an email macro. Specifically, I used the one from this website: https://www.wallstreetmojo.com/vba-send-email-from-excel/ However, when I run the code, it says the following: Can somebody please help me fix this issue? Thank you! Kind regards, Jyggalag

Hi All, I currently have a setup similar to this: I want to create a trendline for the 2022 bar charts. My issue is that no matter which one I pick (exponential, linear, logarithmic etc.) it doesnt touch the top of the bar charts for 2022 and it seems to just go through them. Does anybody...

Dear All, I currently have a setup that looks approximately like this: I would like to know if there is some record macro / VBA solution to separate the emails so email 1 goes into Column K, email 2 into column O and email 3 into column S? I tried to record a macro and use "text to...

Dear all, I am currently working on a spreadsheet that looks like this, albeit the real one is much larger: I was wondering if there would be some way in which I could create a macro or some VBA code attached to a macro where, once i press it, it takes the e-mails from C2-C12 and takes the...

Dear all, I am currently trying to return some data from a larger database. I have created a test sheet that is very similar to the real sheet that I am working with, for the sake of privacy and making things easier to understand from an outside perspective. Currently, I have the following...

Dear all, I feel like most IndexMatch tutorials are very complicated. Does anybody have a good link or video that explains this formula, preferably with an iferror in front as well, understandable for a tech newbie like me? :) Thanks!

Dear all, I am currently sitting with a rather large sheet of data. I have made a smaller, and more simple data sheet for simplicity's sake. Currently I have the following information: As you can see, the data for 2016 has already been filled out (through an old and more manual method)...

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

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

Dear all, I am completely, absolutely 100% new at Power BI. This is my first official day, so please bear with me :) I currently have the following Dashboard: Now, if I insert an image I can get it it to fill all of the screen except for below the dotted line (my red arrow is pointing at...

Hi all, I have the following list: Does anybody know how I can sort this alphabetically? :) Kind regards, Jyggalag

Hello everybody, I currently have an excel sheet that looks similar to this (but much larger): And then a master data sheet next to it that looks like this: Please note that some of the titles are not in the master data set (in reality however, they all are, i just created this example...