field settings

  1. T

    Pivot Table Calculated Field subtotals

    I am working on a pivot table based on data that has a region, a sub-region, dates, and then the available work potential in each sub-region by date. I need to do two things, 1. I need to create a calculated field based on the available work potential 2. I need to change the subtotals to...
  2. M

    Using With...End statement to set fields for two userforms

    Hello, I am a VBA neophyte learning on the job. I have two userforms that I am programming for a spreadsheet. Each user form uses many of the same fields, and so in the code for each userform I have to set the fields up in the same way, i.e. below txtTodayDate.Text = Format(Now()...
  3. J

    VBA for changing all field settings in a Pivot Table

    Hi there, I have a pivot table that has about 35 columns and I would like to quickly change all of the field settings (eg. from sum to max) The macro that I have works in principle, but it crashes every time after two or three fields are changed. Any suggestions for improvements or...
  4. L

    Mail merge format issue **NOT a toggle switch issue***

    I have an very large excel spreadsheet. I use a userform for data entry. I have a field that should read a word but it merges a time instead. For example the field should read "Attorney Fee" but instead it reads "12:00 am" instead. The field is "General" and I even tried changing it to...
  5. H

    Move data in pivot table from subtotals to columns

    Hi, I need to work with large amounts of data to get information from rows to columns. I'm pretty sure its with a pivot table. How do I do this? I was able to move the data to one single column in the pivot table "field settings" then "layout", however I need each item in its own column...
  6. L

    Pivot Tables - retain calculated field formats

    I am trying to learn how to retain calculated field settings in a Pivot Table. I have a pivot table with a huge amount of data and have inserted calculated fields to show the % yearly change, % monthly change etc. I have formatted these as a '% of difference from year previous' etc through the...
  7. srizki

    Pivot Table Question

    In my pivot table, I want non-productive hours and total hours side by side in the same row. The problem is that non-productive hours are showing as count of non-productive and not as sum of non-productive, unless I put them in DATA field with total hours that creates two lines item. When I put...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top