@@veebee3969 i guess you need to use a for loop

@DavidWhittley thank you David. Always nice to hear such comments :)

Thanksss! One of my earlier videos in the channel 😇

@@marinibudiarti2601 thanksss Marini!😊😊

Was super hard to develop. the bad news is i heard they will change the api call in May 2025 for new users...I guess i will have to modify it when it happens 😅

Sub UseIndexMatch() Dim ws As Worksheet Dim result As Variant Dim lookupValue1 As Variant Dim lookupValue2 As Variant ' Set the worksheet (change Sheet1 to your sheet's name) Set ws = ThisWorkbook.Worksheets("Sheet1") ' Define the lookup values lookupValue1 = ws.Range("A117").Value ' The row lookup value lookupValue2 = ws.Range("A113").Value ' The column lookup value ' Use INDEX and MATCH On Error Resume Next ' Optional: To handle errors result = Application.WorksheetFunction.Index(ws.Range("G4:AN106"), _ Application.WorksheetFunction.Match(lookupValue1, ws.Range("A4:A106"), 0), _ Application.WorksheetFunction.Match(lookupValue2, ws.Range("G3:AN3"), 0)) On Error GoTo 0 ' Re-enable error handling ' Output the result (can also assign to a cell or variable) MsgBox "The result is: " & result End Sub

@EXCELWIZARDINMINUTES A very quick response , I appreciate that , thanks I'll try by tomorrow , and give you the information as soonest I get the result , once again thanks a bunch

@@alirezashojaei4634 u might wanna watch this video: kzbin.info/www/bejne/gouwgXesrpVoqrc

@TK-ne2yo thanksss! Was not easy to get it right 😅

I have left you the detailed steps to cover as many scenarios as possible, but i would say try to log in from your PC so the website doesnt ask you to log in anymore when power query runs.... To import data from a website that requires login using Power Query in Excel, follow these steps: Step 1: Check Website Authentication Type Determine whether the website uses Basic Authentication, OAuth, API Tokens, or Cookies. This can often be found in the website's documentation or by inspecting its behavior when logging in. Step 2: Open Power Query Go to Data > Get Data > From Other Sources > From Web in Excel. In the URL box, enter the website's URL. Step 3: Enter Authentication Details When prompted for authentication, Power Query provides options depending on the website's requirements: Anonymous: If the website allows data access without login, choose this. Basic: Enter your username and password directly into the provided fields. Web API: If the website uses an API key, enter it as a header. Example: API Key = Bearer your_api_key. Windows: Use this for internal company websites (e.g., SharePoint). Step 4: Handling Advanced Scenarios If the website requires a session or cookies, you may need to perform the following: Option A: Log In First and Use Cookies Open the website in your browser and log in. Use the browser's developer tools to inspect the network requests: Right-click on the page > Inspect > Go to the Network tab. Copy the necessary cookies or session information from a successful login. Add this cookie/session data into the Headers section of Power Query using an Advanced Web Query: Go to Data > Advanced Query Editor. Add headers like: let Source = Web.Contents("yourwebsite.com", [ Headers = [Cookie = "session_id=your_session_id"] ]) in Source Option B: Use a Login API If the website has an API for login, use it to get an authentication token. Use this token in the headers of your Power Query request: Example: let Login = Json.Document(Web.Contents("yourwebsite.com/api/login", [ Content = Text.ToBinary("{""username"":""your_username"",""password"":""your_password""}"), Headers = [#"Content-Type"="application/json"] ])), Token = Login[token], // Extract token Data = Web.Contents("yourwebsite.com/api/data", [ Headers = [Authorization="Bearer " & Token] ]) in Data Step 5: Load the Data Once authenticated, Power Query will load the data preview. Apply transformations if needed and click Close & Load to bring the data into your worksheet. Important Considerations * Security: Avoid hardcoding sensitive credentials directly in Power Query. Use secure methods to store and retrieve credentials when possible. * Dynamic URLs: If the data URL changes based on user actions, inspect and replicate the URL in Power Query.

@@saheed8218 Hi Saheed, thanks for your question! To maintain the axis order in your Excel dashboard when using slicers, you can try the following solution: Add a Sorting Column: In your data source, create a new column with a numerical value representing the order you want for your axis (e.g., 1 for the earliest year, 2 for the next, etc.). Sort by the New Column: Go to your Power Pivot table, and in the "Model" view, select the field you use for the axis (e.g., Years). Use the "Sort By Column" option to sort it by the newly added sorting column. Refresh and Apply in Slicers: Refresh your data, and your slicer selections should now maintain the specified order.

@shanksingh7613 thank you 😊

You r welcome !🙂🙂

@joelabacherli1310 excel can be boring sometimes. We have to make a bit more fun :)

@@azbakaru6980 try first doing the example i have to learn the introcacies. Once it works for u, u slowly try ur dataset

@GargiUSC Solution for Limited Combo Chart Options: Check Excel Version: Combo charts were introduced in Excel 2013. If you are using an older version like Excel 2010 or earlier, this feature will not be available. Recommend upgrading to a newer version (Excel 2016 or Office 365). Manually Open the "Change Chart Type" Dialog: Select the chart they want to customize. Go to the Chart Tools ribbon. In the Design tab, look for the Change Chart Type button. This will open the dialog box where you can choose the combo chart type. If the Dialog Box Doesn’t Open: Verify if Excel needs updates or repairs (use File > Account > Update Options). Check for add-ins or settings that might disable dialogs (e.g., Excel running in Safe Mode). Alternative Path to Create Combo Charts: Go to Insert > Insert Combo Chart (in Charts group) > Choose "Custom Combo Chart." Select the series for the stacked and clustered options.

@@EXCELWIZARDINMINUTES I have Microsoft Excel 16.92 I have also reached out to you on Instagram

excel can be sometimes frustrating. one small thing and we spend hours hehe

When you only see one Pivot Table in the Report Connections dialog box for linking a slicer, it's typically due to one of the following reasons: 1. Pivot Tables Are Not from the Same Data Source Explanation: For a slicer to control multiple Pivot Tables, all the Pivot Tables must be created from the same data source. Solution: Verify that all your Pivot Tables are based on the exact same data source. If one was created from a different table or query, Excel won't allow the slicer to connect them. Steps to Check: Click on each Pivot Table, then go to PivotTable Analyze > Change Data Source. Ensure the data source is identical for all Pivot Tables. 2. Pivot Tables Are in Different Workbooks Explanation: Slicers cannot connect Pivot Tables that are in different workbooks. Solution: Move all Pivot Tables into the same workbook. 3. Pivot Tables Are Not in the Same Cache Explanation: Even if the data source is the same, if you created the Pivot Tables separately (instead of duplicating an existing Pivot Table), Excel may treat them as separate "data caches." Solution: Use the same Pivot Cache for all Pivot Tables. To ensure this: Create the first Pivot Table. Copy and paste the Pivot Table to a new location, then modify it as needed. This ensures all Pivot Tables share the same cache and can connect to the same slicer.

@EXCELWIZARDINMINUTES thank you

@@rdp1911 thanksss a lot! 😊

@zanyaryit i am sure u haven't enabled macros. Here are some steps to troubleshoot: 1. Unblock the File in Windows Locate the file in File Explorer. Right-click on the file and select Properties. In the Properties window, look for a checkbox or button labeled Unblock under the General tab (at the bottom). Check the box (or click Unblock) and click OK. 2. Enable Content in Excel Open the file in Excel. If a yellow security bar appears at the top of the workbook with a button labeled Enable Content, click it to allow macros. 3. Ensure Trust Center Settings Allow Macros Go to File > Options > Trust Center > Trust Center Settings > Macro Settings. Ensure macros are enabled: Select Enable all macros.

@mayurnaik8038 Thanks Mayur! 😊

@SaunakDey thanksss Saunak! 😊

@pascalcrblancquaert4058 thank you Pascal for the kind message. I m happy i m able to pass on the knowledge i accumulated all these years 😊

Thanks for the feedback Kathy :)

Hey Cara, I believe there is a comment below with the same question. try the answer i provided :)

@alishasong3847 Yes, it is possible to connect two slicers if they are based on the same data source. Here's how you can do it: Steps to Connect Slicers: Ensure Both Slicers Are Based on the Same Data Model: Both the map table and pivot table need to come from the same dataset or data model in Excel. This is essential for slicers to interact with each other. Create Relationships (if applicable): If you're using a data model with multiple tables, make sure there is a proper relationship established between the tables in the Power Pivot data model. Add Slicers: Add slicers to your map and pivot table if you haven’t already. Go to the Insert tab → Slicer. Connect the Slicers: Select one slicer. Go to the Slicer tab on the ribbon. Click on Report Connections (or PivotTable Connections in older versions). A dialog box will open, showing all the pivot tables that can be connected to this slicer. Check the boxes for all relevant pivot tables (including the one used for your map and the other charts). Test the Connection: Now, when you use the slicer, it should filter both the map and the pivot table charts simultaneously. Note: If the map is not updating, verify that it is dynamically linked to the same data source. For advanced interactions, consider using Power BI, which offers more robust slicer functionality across visualizations.

@@ronqmo8755 am happy it s useful 😊

@travisalejandro6690 in the past i used to put the sentence in google translate and copy paste 😅

@EXCELWIZARDINMINUTES well, it sucks that Microsoft don't really make effort in integrating AI into office, so we have to use chatgpt separately since it's preferably in creating more natural sentences. So yeah, copy-paste will not extinct in near future.

Great i helped ! 😊

@@mra893 graciasssss :)

Thanksss :)

@@surjagain thanksss :)))

😊

@@alfeocayabyab8233 i m happy i helped 😊

@vittorialaudani5140 hello vittoria. Ur timing is perfect. I am editing a new vrp video that will come out next monday. It will use google maps api instead of bing to solve. For the time being you can use this to do the step the vrp solver needs. Otherwise just bare with me for 7 days and u ll get a new vrp solver...u can subscribe and put notifications on so u know when the video is out. But it s definately next monday...let me know if this works....

@@EXCELWIZARDINMINUTES that's great, I'll try with the Google api but I will surely watch your next tutorial too

@vittorialaudani5140 basically in the vrp sheet, u need lat long for 1 sheet and the distance and time between each combination of locations. This excel can give you all this. And u can copy paste them. However be aware than in the vrp solver, u need the times in days (u need to convert min to days. Ie /60/24). The simplest thing is just to wait 7 days. Then in 5 min, u can do vrp :))

there is the new video: kzbin.info/www/bejne/Z6uQn4eKjsmHmbs Plz like it and comment if possible :)))

Welcome!😊

@tanakornpromthep9025 always nice to hear such nice words 😀

@humanbeing888 hard to achieve the same functionality. Vba coding might help though

@CVgeek To add an image in the body of an email sent using VBA, you can use the HTMLBody property of the email object in combination with HTML to embed the image. Here is an example of how to send an email with an embedded image using VBA: Step-by-Step VBA Code Make sure you have the image you want to embed saved in a folder. Use the following VBA code to send an email with an embedded image: Sub SendEmailWithImage() Dim OutApp As Object Dim OutMail As Object Dim imgPath As String Dim strHTML As String ' Path to the image you want to embed imgPath = "C:\path_to_your_image\image.jpg" ' Create the Outlook application object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) ' Define the HTML body with the embedded image strHTML = "<html><body>" & _ "<p>Hello,</p>" & _ "<p>This is an email with an embedded image.</p>" & _ "<img src='cid:image1'>" & _ "<p>Regards,</p>" & _ "<p>Your Name</p>" & _ "</body></html>" ' Compose the email With OutMail .To = "[email protected]" .Subject = "Email with Embedded Image" .HTMLBody = strHTML ' Attach the image and reference it with the Content-ID (cid) .Attachments.Add imgPath, 1, 0, "image1" ' image1 matches the cid in the HTML .Display ' Use .Send to send it directly End With ' Clean up Set OutMail = Nothing Set OutApp = Nothing End Sub Explanation: imgPath: You set the path to the image file that will be embedded in the email. strHTML: This is the HTML body of the email. The image is embedded using <img src='cid:image1'>, where cid:image1 is a reference to the attached image. .Attachments.Add: This attaches the image to the email. The fourth parameter ("image1") links the attachment to the cid:image1 in the HTML body. You can modify the paths, email addresses, and body content as needed.