fields

Hello Using Excel 2010 I have these two pieces of code below that put 2 fields into the page area of a pivot table. I want to choose 2 out of 40 items in OrderID I want to choose 1 out of 20 items in CustomerID Is this possible without having to write true vs false code for each item in VBA...

Hello Using Excel 2010 I have these two pieces of code below that put 2 fields into the page area of a pivot table. I want to choose 2 out of 40 items in OrderID I want to choose 1 out of 20 items in CustomerID Is this possible without having to write true vs false code for each item in VBA...

I am querying two tables. I am trying to show all the fields from one of the tables, in my query results, by using the *. I want to sort by one of the fields. is there a way to do this when you're using the * to identify the fields?

hi, I have the following formula which works well for me when it captures criteria based on one cell value. =IF(ISERROR(INDEX(employee_names,SMALL(IF(day_1=$A$11,ROW(day_1)),ROW(1:1))-1,1))," ",INDEX(employee_names,SMALL(IF(day_1=$A$11,ROW(day_1)),ROW(1:1))-1,1)) I'm trying to expand it to...

For work, need to save a csv file to be sent to customer. They upload into their system for invoicing. For some reason, the csv I'm sending, they say is in the wrong format and fails when uploading into their system. After looking at the data, when you open the file with notepad, the text...

Hi all, Does anyone know how to unselect the fields in the rows selection in a pivot table. Ive removed all fields in the pivot table but I would like to keep whats in the value and columns? Thanks

Hello guys, I'm trying to take a range from each sheet and add it into array. The selected ranges will always be the same size so only the first dimension of the array needs to be redimmed You can use: arrayInQuestion = Range("M1:M30").Value To set an array to be equal to a range, but after...

I have tried for 3 days to get this to work. PLEASE HELP ME Sub SendEmailUsingYahoo() On Error GoTo Err Dim NewMail As Object Dim mailConfig As Object Dim fields As Variant Dim msConfigURL As String Set NewMail = CreateObject("CDO.Message") Set mailConfig =...

I have two value fields in my pivot table. (1) Count of IP - showing the number of hosts out of compliance. (2) Max of Category Host Count - showing the total number of systems affected by a specific technology. I want to have a third field dividing field 1 by field 2 so I can show the...

How can I create a Word template and fill some of its fields from specific cells of an Excel sheet/workbook? Is that possible? Any guide how to do it? Thanks!

Thanks in advance for anyone's suggestions. I will give feedback on any suggested solutions. Why am I getting a "Compile error: Invalid Qualifier" on "xlDataField" within the line: 'Add item to the Data Field to either Count or Sum. In this Case Sum With...

Hi all, I'm currently using this code to toggle pivot table row fields, there are buttons on my spreadsheet that I click to add/remove row fields in the pivot table. This works great, however I was wandering if it is possible to adapt the code to toggle pivot table data field "values" by...

so in a pivot table i recently learned you can choose to repeat or not repeat a columns fields by right-click / field settings / layout & print and then checking or unchecking the Repeat Item Labels box. The last few times I've tried to though that box has been grayed out. Any guesses as to...

Every time I click outside of a pivot table the fields on the far right disappear. I'd like to keep them on all the time. Is there a way to do this? Google hasn't shown a solution.

Hi there, I have 67 fields in column A and B beginning in A2 and B2 - I would like to take the first value in A2 and place it in D1 and then the value in B2 and place it in E1. I would like to then add a column with "Diff" in F1. This column should be formatted to display a percentage value and...

Strange (to me at least) behavior from double clicking on a cell with data in a pivot table. Hoping someone can give me some insight. We're running Excel 2013 Professional on Windows 10 Enterprise. I have a pivot table using the "data model" functionality (i.e. in order to make "Count...

I have an input menu that allows users to input the serial number of a product and then check off what listed parts are either missing or pulled from said product. However, I want to be able to update certain serial number's fields without creating a whole new row for the same serial number...

Morning all, I have checked what I think are all the obvious things to check but when putting 2 fields into the values are I get zeros....it by default is counting them, so when I amend to sum it stays as zero I have made sure all the numbers in the 2 fields are in fact numbers and not text I...

I setup a drop down box, how can I use the item selected to auto populate other fields? Contact Name Telephone Number Email Address Drop Down Box Auto Populate Auto Populate

When I load an Excel sheet in PowerBI, I was attempting to rename the fields in PowerQuery by filtering out the fields and renaming the ones I want to by replacing the values However, I cannot retrieve the fields that I filtered out. What is the proper way to do this?