andrew poulsom

  1. vds1

    Where is Andrew Poulsom - MrExcel MVP ?

    Hello Folks, Andrew Poulsom - MrExcel MVP last activity shows May 21st, 2017. He was my guru in Excel with Total post of 73,092. I was wondering if anyone knows about his well being. Thanks, VDS
  2. T

    Recorded Macro Gives "1004" Error When Runs

    I am trying to insert a formula -with so many functions- into a cell using VBA, in order to include it in my bigger code. I wrote the function inside the cell itself and I am using "Record Macro" to get it in the VBA format. The formula itself works perfectly in Excel, before recording it. When...
  3. K

    Assigning If function to a Shape instead of a Command button

    I am trying to assign the following script to an Image as I do not want to use a command button. Upon running it gives me an "Object Required' error message. Kindly assist Sub SaveForm() If TextBox10.Text = "" Then Cancel = 1 MsgBox "Please enter Contribution Ref # field before saving the...
  4. V

    Need Help in Pivot Table!!!!

    Hi All, I need to create a Pivot table of a data where I have some values as %s and some values are as Numeric. I need to show data in pivot table as %s where data value as % and data as numeric where data values are numeric. I have created a new variable where I have multiplied the data...
  5. G

    Complex SUMIF formula

    Hi, I'm trying to use a SUMIF formula in which the criteria is in one column but it has multiple sum ranges determined by the values in a row. Below is a summary of the worksheet from which the formula is being linked. The first column (numbers 1 - 5) and top row (K.5.1.3) represent the...
  6. S

    How to reference file paths given in text box on user form by a user and then perform execution using command buttons on the given file path.

    Hello All, I have certain tasks to be performed for which I have my command buttons on a user form. what I need to do and facing difficulty is that I want the user to input his/her required file name in a text box on the user form and the command buttons should perform execution on that file...
  7. M

    how to convert numerical numbers to words in MS excel & MS world

    how to convert numerical numbers to words in MS excel & MS world

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...