indexmatch

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

Dear all, I have currently made a pivot table, which I am linking to some Power Query data. The data in the power query comes from a folder where I import files from a website, so these files will ALWAYS have the same file name, sheet name and column names. However, the data under their...

Hi all, I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query. I want to import data into this pivot table (not using power query below): I have the source data saved here: So questionnaire data file 1 is week...

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

Dear all, I currently have this VBA code (please note the part highlighted in bold): Option Explicit Private Const FilePath As String = "\\COMPANY.SSSS.COMPANY.NET\userdata\t5382304\home\Documents\TEST folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i...

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 email macro: Now, what I am wondering, is whether it might be possible to ignore certain emails from being targeted on the list that I have designed in my "for i = 2 to 10" code? A nice solution personally for me would be if I could simply just highlight the cell...

Hi all, I currently have the following VBA code attached to a macro that sends out an email and attaches a word file to it when I click it and sends this out to a list of emails (and also BCC's a list of emails): Now I want to edit this file so I can target a list of emails in the emails...

Hi all, As far as I know, Pivot Tables are incredibly useful. However, I have never had the chance to actually use them in my work or private life. Does anybody have some simple examples where pivot tables are useful? And what do you guys use them for? Thank you! Kind regards, Jyggalag

Hi all, Does anybody have a nice template, structure or similar wording for a table of information with data being pulled in from a large master data sheet (I imagine through an INDEXMATCHMATCH / VLOOKUP formula, those tend to be the best options in my experience)? The nerdier the better :D...

Hello everybody. I want to do something rather large, but I am very inexperienced in VBA and would really appreciate some assistance. Please note that I want to do a bunch of things, but if you can just help me with one of them, it would be immensely appreciated!! - Wishlist: @Fluff ? :) So I...

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

Hello Everyone, I don't know if this is possible but I'm hoping someone can help. I have a set of data in the A column that is all linked to one piece of data. Within that data has multiple numbers. For instance, I'd like a formula to pull every number next to tire onto each article. I would...

I have two separate workbooks. I'm wanting to use an Array Formula to search through the external workbook, find the column header header "Si" and populate all external column data into my local workbook. Can I use Index/Match or Xlookup for this?

Hello friends :rofl: I am in need of an INDEX MATCH formula that looks up one column OR another column. Our group accounts are listed in one column and the accounts that comprise said group account are listed in another column. EG group account 15000 is in column A. 15100, 15200, 15300...

Hi I need help here, do anyone know how to translate the below formula into vba IF(LEFT(K5,1)="#",0,MAX((L5-INDEX(WorkingHrs[To],MATCH(J5,WorkingHrs[Working Hours],0))+(L5< index(workinghrs[to],match(j5,workinghrs[working hours],0))))-index(workinghrs[hours],match(j5,workinghrs[working...

Hi, I'm trying to identify items that have two specific values (<blank> in Owner Name) spread across two rows (Owner Role="Primary Site Owner" OR "Secondary Site Owner") with one common identifier (Site URL) and, if the conditions are met, insert a note in the column of these row(s) (Owner...

hi all, i am looking to analyze a large set of data and to do so have developed a sort of basic dashboard. in said dashboard, there is a dropdown (data validation list) with a month name that corresponds to the data set i am analyzing and in which the months are listed horizontally across the...