field

I have a table of data with three columns: - company code - company name - sales When we use Pivot Tables, we would drag, say, Company Code to the rows field and Sales to the total field. But how about if we wanted to see the company name corresponding to the company code... how would you go...

This is the code I'm using:Sub a_Recalc_Pivot_Table() ' Macro to recalculate Pivot Table. ' 2/7/12 Modified. WML ' ' 7/29/19 Copied from "Offfice Development Center". WML Call Initialize_Globals Data.Activate 'Determine the data range you want to pivot...

Need some assistance please. I have created an Excel Form that has a combo box field - cboCallType. One of the options in the combo box field is 'Other (Please enter details in the Notes Field). What I would like to do is to make the Notes field - txtNotes - mandatory only if the user selects...

Hello everyone. I am back again. The code bellow is working to an extent. However, when I click OK to the Error I get, it clears the field BUT the customer name field (tbnbna) does not get the setfocus. Private Sub tbnbna_AfterUpdate() If Application.WorksheetFunction.CountIf(Range("A:A")...

I have a pivot table and one of the values I changed the value field setting to "AVERAGE" but the calculated field is calculating based off of sum. How can I get the calculated field to calculate off of the average? The Surplus Shortage field is my calculated field where I am taking Inventory...

Hello, When I try and remove a calculated item that somehow (user error) got added to my sheet, the following error pops up: "The pivot table field name is not valid. To create a pivottable report, you must use data that is organized as a list with labeled columns." Help? Thanks! -Ben

Hi I am automating the inputting of text and date/time fields using VBA and IE. The site concerned has AngularJS java scripts running behind the HTML. I have triggered events to handle the date and time picker by clicking on buttons navigating the calendar if the month/year does not match...

I have created a sequence in VBA that makes a Pivot Table out of a named data Range - Data. The data sections work fine, but I need a new field that calculates the Sum of the two data fields. I tried this: With ActiveSheet.PivotTables("SalesPivotTable").CalculatedFields.Add "Difference", _...

Hello you all, good people. It has been a few years last time I have been around. I have been dwelling with the code bellow and the setfocus function is driving me nuts, as it's not working. Instead, the cursor is moving to the next field in the form. What am I doing wrong please...

Question 1: Using the date field below, I would like to create a new field that subtracts today (current month/year) from this field's format below. There are some fields that do not have a date value ('-' or blank) - in those cases output a '-'. Current Formula...

I have a pivot table where the columns are grouped by year then month. The years are 2018 and 2019 with January-December in 2018 and January-June (so far) in 2019. Is it possible to create a field (maybe a calculated field) that will provide a sum of 2018 columns in between December 2018 and...

I have the below Formula using LARGE and right now it returns the largest value in the column, but the Column is a UID field and I am just using it to determine unique value, I want to somehow wrap this formula with and INDEX / MATCH array and first use LARGE to find the largest UID, then using...

I use the macro below to sort a Pivot table descending based on the value cell I have selected in Pivot Table value section, regardless of how many Row Labels there are. It works for a standard Pivot Table, but not one that has been added to the Data Model. Any ideas as to what needs to be...

So I have tried so many different ways before reaching out to you guys. Is there anyway to have a CSV file with leading zeros in a number field that will not drop the zero when reopening the file?!

I have this code below to where I select a name in cell I4, and then click run in cell f4, and this filters to that name in each pivot table on the page. This always worked before but all of a sudden stopped working? Also, is there a way I can write this to where if you just select another...

I have 2 queries: Both Queries have the same fields and are based on the same table (tblBusinesses) but have different criteria <tbody> Query Name Criteria OpenBusinesses 'Status' field equals 'Open' ClosedBusinesses 'Status' field is not equal to 'Open' </tbody> Is there a way to find...

Hi, First time poster long term lurker :) Wonder if someone can help me out? I have a one to many relationship I need to add up. On my first sheet I have the 'one', a server in field A with my formulae in field B On my second sheet I have the 'many', the servers numerous disks in field C. I...

Hi all - I am trying to include a year over year $ difference in my pivot table but all the examples I see have the dates in a row field vs column. I want to just have one column after 2019 #s that calculates the difference from prior year. If I drag the amount field again in the values...

I have an Access "Membership-type" database with two tables as follows: - [Countries] with the "CountryID" field set to autonumber and Primary Key and "ContactCountry" set to text - [Members] with the usual data for a membership database including a "Country" field set to Number (using the...

I have a table that looks like this. I have two variables that I need to select for the index match, namely Field and Portfolio. I have selected portfolio y and Field 1. I need to obtain value 2, but using index match, i can keep obtaining value 1. It doesnt work when I change my column range...