problem

The Cardinals for friends worksheet have some #NA . I not how to fix time problem. picture of problem https://1drv.ms/u/s!AnJwxxiz0Ezpg8do84YcIJ5oZ_8T0A?e=tYnSMh get file link below https://1drv.ms/f/s!AnJwxxiz0Ezpg8dpKW10NS9p7fke-A Thanks You Thomas

Hello, Im looking for a way to generate random numbers when my standard deviation and mean are fix. So i used google and YouTube and there are many tutorials. (Like this: https://www.extendoffice.com/documents/excel/2472-excel-random-number-mean-standard-deviation.html ) The problem is: every...

Hello all! I'm trying to set up a custom sort in VBA, but I ran into a problem. I'm establishing the array to use for the sort and it's fine except that one of the items being sorted is called "Invoice, Commercial" and it's affecting the sort, since there are commas separating the array...

I put name of them user form name.show will not open the form ty Thomas

Hello everybody, I'm working on a basic assignment problem with the solver. I would like to assign a customer to our company's office. So, I would like to minimize the transportation costs between these two locations. I have no difficulties in accomplishing this. but if the distance...

Hi all, Not sure if this is best done via excel solver, formula, or VBA, but I have the below problem: A cell setting a maximum size, set in this example to '25'. A set of numbers, which cannot be split, only combined, to fit into groups equaling 25, e.g.: <colgroup><col width="64"...

Microsoft Excel 2007 Column P52 contains this formula: =IF(C52>10,IF(E52>15,IF(G52>20,IF(I52>50,IF(K52>100,"Pass","Fail")),"Fail"))) Columns C, E, G, I, K contain marks in numerical. My problem: If I52 is less than 50 result in P52 should show "Fail". Instead it shows "FALSE"...

This has just started to appear as the workbook loads. It continues to load and everything seems fine .. until I try to Hide or Unhide something. Some cols are ok and some bring up the error again. Is there anything I can do to fix it ?

Hi, Brand new here, and I'm having a little trouble with the site. First problem I ran into is trying to paste VBA code onto a post. I click the "paste as plain text" button, a window pops up, I hit ctrl+v, submit it, and nothing happens. Sometimes the window won't even pop up. I've also...

Hi, First of all, thanks for the guy who created this macro, it almost works perfectly! Here's the macro : Public FunctioLastmodified(c As Range) Lastmdified = Now() End Function THOUGH! I'm facing this problem : Every time I use the filter in my table, ALL the dates are updated and I don't...

Hi, I am trying to move text up in a range when there is empty rows above or in between. I thought I had got it to work but I just found out a big problem, it clears and copies the wrong rows. Does anyone of you experts think you could help me out with this problem? Here is an example of the...

Hi guys, I've searched for an answer to my question but don't seem to have any luck since this is somewhat of a unique problem. I have a very extensive vba program that I've designed for my company. I figured that before I'd start adding even more to it that it would be a good idea to...

Hi all, I'm attempting to write a macro that puts data into a pivottable automatically. This seems pretty simple, but I can't quite figure it out. I think there is a problem with the name of the table and location its going to? I'm not to sure. I'm getting the Run-time error '1004'...

Hi Internet People I have the following Problem: The Time Axis of my Diagram only shows Zero-Values. The Values for the time axis are generated by a formula that puts there an empty string when the value in the raw data sheet is missing. Exactly that empty string makes then problems for...

Hi, I've been having a problem for a while throughout on different laptops (HP, Asus, Lenovo) and never seem to find a solution for it. What happens is that after a while working on excel, when i issue a keyboard shortcut like paint a cell, turn text bold, copy paste, freeze panes, etc... excel...

I have a massive workbook, that has macros, and pulls data and places it in another file. When I place it manually, and then update the pivot tables, it has no problem. When I allow the macro to place the data, (it places it in exactly the same place), then I refresh the pivots, it tells me...

Hi I get an error after closing and reopening the excel book. "We found a problem with some content in "XXXXX.XLSX". do you want us tor try to recover as much as we can? if you trust the source of the workbook. click yes." I tried solutions found online but no avail. I have a fairly simple...

after researching..i couldnt really come up with much results which is why im posting here. 1] is it possible to make out combinations with the given data? 2] also, i have to make sure that when it is combined, the total =10 not more or less Here's the data: <tbody> a b c d e f g h i o p q r...

Good morning, I have a problem with a macro that runs in windows 7 but on windows 10 it runs with a small problem. Macro: Sub XXX() ' ' Macro1 Macro 'Sheet of the activeworkbook that you want save as separated workbook Sheets("XXXXXXX").Copy Dim Path As String Dim...