excel 2016

  1. C

    Excel 2016 Total or Subtotal Row ignoring hidden columns

    Hi all, I am trying to create a subtotal across a row like you would down a column, however, when you try to subtotal a row the calculation appears to include the hidden information. I have a Spreadsheet that contains numerous macros which hide\unhide columns of data, however, when I try to...
  2. Johnny Thunder

    Formula Help - SumProduct Formula to return value only once in the event of duplicate row

    Hello all, I have a spreadsheet that contains a list of PO Numbers, the list may at times have the same PO repeated on different rows. I need a modification to my formula to be able to only show the result once if there is a duplicate row. Not sure of a way to do this so hopefully someone has...
  3. D

    For each listrow - update data

    HI! I'm a beginner (at best) with VBA loops and would need to adjust data in Excel table rows, depending on a single column cell value. I want to loop through all rows for this table and adjust data depending on value in 3rd column ("Check"). If column "Check" value is 1, insert value "Disable"...
  4. D

    How to output a dynamic range where the height of the range varies

    Hi, I have a search tool that returns a dynamic range. I'm trying to get it so that the outputted dynamic range is staggered. I get this: <colgroup><col style="mso-width-source:userset;mso-width-alt:5266;width:108pt" width="144"> <col...
  5. Johnny Thunder

    Formula Help - SumProduct with multiple Conditions that include a wildcard

    Hello All, I am hoping this is an easy one, I have a sumproduct formula that looks at multiple conditions and it works great but the business just threw in a new variable and I was hoping it will be a quick modification to the formula to get it to work. Here is the formula...
  6. D

    Trying to sort dynamic table in order of number value of first column (this column contains duplicate values)

    Hi, I have a dynamic table that I'm trying to sort by the value of the cells (that have duplicate values) in the first column A. I would start of with this: <tbody> Column A Column B Column C 3 cat Cats Rule#1 3 cat Cats Rule#2 3 cat Cats Rule#3 1 dog Dogs Rule#1 1...
  7. E

    How to copy values from one workbook sheet to another, based on criterias ?

    <button title="This question does not show any research effort; it is unclear or not useful" class="js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer" aria-pressed="false" style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image...
  8. Johnny Thunder

    Excel Formula Help - SUMPRODUCT with Array of ID's

    Hello All! Not sure if this is possible but can I create a SUMPRODUCT formula that contains an array of ID's? Below is the mock up of ID's that referece a Named Range "Cdata". This formula works if you duplicate and enter in a single ID (1256, 1261 ect.). Any help is appreciated...
  9. Johnny Thunder

    VBA Help - Search Column For String, Do Something, Repeat Search

    Hello all I am working with a code that does multiple Loops thru Sheets based on a Matrix, the Matrix contains a Product ID that will need to be searched on specific sheets. For this search, there will always be at least one value found on the sheet the code navigates too. Search column will...
  10. A

    odd cell behavior: can overwrite cell contents but not edit cell contents

    My users are running into a problem that I can't solve. In one particular cell they cannot edit cell contents. They can write in whatever they want - but only by replacing the existing contents. So for example say it contains the string "Workpaper" and my user wants to make it say "Workpaper...
  11. Small Paul

    Macro Works in Excel 2013 but NOT in Excel 2016

    Hi I have a number of macros I have written on Excel 2013. I am now transferring them across to other users' machines as I am leaving. They all run Excel 2016. For some reason, the macros fail on 2016. The start of one macro is as follows: Sub Daily_Open_Trades_Pivot() ' '...
  12. B

    COUNTIFS with Date Criteria Help

    I have a report I pull from one system into Excel format. I process it with some queries in Access and export it out to Excel. At no point do I actually edit the data in the field, but it is getting passed back and forth. The issue does happen in the source document, so the passing back and...
  13. Airwave

    VBA and Hidden Columns

    I am trying to get the below to work in columns that are hidden from view in Excel. It does work, but only if the columns are not hidden. Is there a way around this? With Sendrng .Parent.Select Set Rng = ActiveCell .Select ActiveWorkbook.EnvelopeVisible = True With .Parent.MailEnvelope For Each...
  14. Johnny Thunder

    VBA Help - Code that does a lookup based on Cell and brings in metadata - Excel 2016

    Hello All, I am working on a project and have this code that works but its super slow, takes 15-25 seconds to bring the data into my sheet? Context, this is a report for an HR Department. A user can drop in a tracking number and from a Data Mart sheet the code looks up the details stored...
  15. Johnny Thunder

    Formula Help - Multiple COUNTIF's to validate if value is in range - Excel 2016

    Hello All, I have a formula that looks at 3 different sheets to validate if the value is in a range but I need help updating or using another method to enter the forumla. Here is what I got so far but its not all the way there. Formula: =IF(COUNTIF('Drama &...
  16. Johnny Thunder

    VBA Help - How to update Range based on Filtered Criteria - Excel 2016

    Hello All, I have come to a spot in this code that I am not sure how to tackle. I will do my best to explain what the problem is, I have one code that is able to be triggered from 3 different sheets, the outcome for all three sheets is the same, the only thing that varies is the data that...
  17. Johnny Thunder

    VBA Help - Combine 2 Worksheet_Change Events - Excel 2016

    Hi group, So I have two Worksheet_Change Events written out but I realized today that you can only have one per page so here is the code, can anyone suggest a revision to combine the two into one so that I can wrap up this project...
  18. Johnny Thunder

    Vba Help - For Loop to enter Text into Cell - Excel 2016

    Hello all, I am working on a project and I have gotten fairly far with this and needed some guidance and possibly some revisions to my code to make it faster and shorter. Objective: 1. I have a Master Data Sheet (Ws2) that has 17 rows of data Columns("B:O"). Thru a loop on Column B, if the...
  19. P

    Providing a list of files in Excel of a directory is slowing down excel

    I need to provide a current list of files in a directory in an Excel workbook and everything is working as required, just too slowly. I really only need the list to check it is current once upon opening the workbook. It takes around 11 seconds to do this which is acceptable but the problem is it...
  20. Johnny Thunder

    VBA Help - Modify a LastRow Lookup line of code - Excel 2016

    Hello All, I have a piece of code that I need to modify since it works so well, it essentially is a Last Row Lookup (Column Based) and defines the last row with an actual formula result. What I need: I have a variable to replace the column letter "ColumnL" that I need to update the line of...

Some videos you may like

This Week's Hot Topics

Top