configuration

Hello, is there a way to keep the default signature associated with my gmail account when sending an email from Gmail through VBA (I am using CDO if that can be helpful). Below is the bit of code relevant to the email configuration: everything works fine except for the missing signature. Any...

Hi, The objective is to come up with the formula in F4 that give you the number of months in takes to deplete the current inventory (F3) based on your current sales forecast (G2:02) (I put the expected results the formula should obtain) I included the expected results in row 4. Note that the...

Hello All, I'm currently looking for a way to calculate months on hand inventory. Looking around this forum I could not really find a simple way to get rid of my problem. My dataset is as follows; <tbody> Model Region Configuration Measure Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19...

Hello All, I need your help. I'm working on a file where I need to search horizontally and vertically with multiple conditions. What i did try before coming asking for help here? a) I tried an array formula which worked. However my file contains more than 50,000 rows. This makes the file way...

I've been watching video tutorials to learn VBA. Sometimes the user rolls his mouse over a line of code to see the result of that particular code. Like when you want to see the result of Range("A1").Offset(4,5), you hover over it and you see what the value is. I couldn't find that...

Hello, I am having some difficulty modeling data with two independent variables and a dependent variable. The data is included below: <colgroup><col><col span="2"><col span="3"></colgroup><tbody> 20000 40000 60000 80000 100000 2017 12375 11000 9475 9250 9250 2016 12100 10800 9450 8150...

Hi All I have a macro which is applied to all worksheets except 'configuration' or 'project managers' worksheets. However, when I run it, it seems the macro also affect these two worksheets. Please could someone help me to resolve this? Many thanks. The macro starts with: Sub report() Dim...

There are several ways to set up ODBC drivers to SQL Server in Excel 2016. There is one method that is cross-platform Mac/PC but this method is not working for me. One way that does work is from the Data tab of the Ribbon choose Connections. I can set up a connection to my SQL Server that works...