excel 2016

Hi all, I made an Excelfile (xlsm) with several connections to a part of a database and set some filters in query. With the filtered query data I made some pivot tables. While validating the file I found out that some data which are available in query, aren't available in the pivot table. When...

Hi! I'd need some ideas in troubleshooting SUMIFS formula that returns #VALUE ! error I have a named ranges (within a table) to check particular "Department" + named range to check particular "Cost_type" and summarize the match. So the formula looks something like...

Hi, I'm using Excel 2016 64-bit and have a ComboBox with a dropdown that contains 150+ lines. I'm trying to set it up so that I can scroll through the lines with the mouse wheel.

I'm new to VBA in excel and I borrowed this code from a previous thread that has worked well. It takes each value from column B in my main tab and creates a named tab with the format of the CONTROL tab and hyperlinks it in the original tab. My problem is that each tab, although correctly named...

Hi, Excel 2016. I am trying to send a PDF in landscape orientation by mail using the ActiveSheet.ExportAsFixedFormat function. If I try printing the sheet it manually it works fine in landscape. But it does not work in VBA. I have googled this issue extensively for no solution. Sub...

First, let me start by saying for thelast 10 years I have worked primarily in Excel. I have literally spentthousands of hours in Excel and never had anything like this happen before... Yesterday, I was working in Excel and had 3 files open. I was no longer using file A so I wanted to save and...

Hi all, I am trying to create a dynamic range to accommodate when the number of rows and columns can change in the data set when creating a pivot table. I created a named range but I cant quite get it to work. Any help please.. =OFFSET('Waterfall 23'!$A$2,0,0,COUNTA(Waterfall '23'!$A:$A)1,1)

I have some code. It used to create a userform called "myUserForm". However, now it just creates "UserForm4", then the next time it is run it creates "UserForm5", then "UserForm6", etc. I must have made a change to something, but I can't figure out what that something could be. I have only...

I have this excel workbook that has a tab for every month. This tracks awards given to my employees. I have a main sheet named Master that holds a few formulas to randomize and the template for the tracker. I need a code that I can put into a button that when pressed creates a new sheet...

Hi! Utilizing Ron de Bruin's code to email Excel range over Outlook in HTML, however could you guys help me understand the conditional formatting part. I want to focus on 3 columns in my range: E; F; G. I have conditional formatting in place for column G based on formula: =F3<>0 e.g. if column...

I am trying to write a VBA code for sending an email of a sheet with 4 pivot tables. These pivot tables are formatted the way the client wants. I am able to copy and paste them to the Outlook email with formatting however: 1) The color of the pivot tables changes from blue to green 2) The...

Hello All, Hitting a wall with the last piece of the puzzle in my code. I am trying to include a variable (Column Letter) in a formula and I am getting an error in the code. Any help fixing this is appreciated! Here is my code: Option Explicit...

Hello I am working with Volpi's Fox Team Matrix and XNumbers add-ins that were not upgraded for Excel's ribbon versions. I created manually new tabs and groups to assign the macros that show the userforms. However, I did not find anywhere how to it using VBA to automate the process, so I am...

Howdy Gang. I'm sure I can't be alone in this... We recently had to upgrade to MS Surface Laptops, with 'Office 365' (though we have the local 2016 installs too) and Windows 10. I've noticed the following problems, one of which jut cropped up the other day, and are driving me absolutely...

I'm trying to design some sort of countif/countifs formula(Sheet 1, Column B) to count the number of clients involved in each job type... -----Sheet 1-----(Column B needs to count the number of individual clients that hired different job types...For Example: Cell B2 should result with 2...

Can someone help me with a formula that will match a cell in column B to a cell in Column A and if they match then bring back the corresponding data from column C?

Hi Group, I am working on a project and have hit a road block. I need to build code to create a range array with a "," separator for each found instance (Example: A2,A5,A8 ) Using this array, I will add the string Formula = "-Sum(" & Code & ")" to create what I need. Currently my data is...

Hello All, I am working on automating a Journal Entry Tool and could use some help with the last part of my tool. In need of code that will loop thru a range of cells and find a matching value to the Business Unit and log the cell.address in a sum formula. Full Description: 1. Column A is...

When I go into Power Pivot in Excel 2016 and Excel 2019 and select Get External Data From Other Sources I get nothing, no Table Import Wizard. Any ideals why? Thank you!

Hi. I'm trying to make a macro on Excel 2016 that will open a certain workbook based on data in a determined range. Once the workbook has been open, the data inside the newly opened workbook will be copy and paste into the last blank row of one Main Excel workbook. This will carry on until the...