chips

  1. J

    vba code for vlook loop

    Hi, I want to set up a simple vlu loop to copy data from one sheet to another and I want the loop to end when when the loop reaches the end of the list. let's assume the list of items with prices (columns 1&2) is on sheet 1 and the vlu required (column 3) is on sheet 2 Its early days for me...
  2. J

    Macro Assistance

    Hello! Ok; I've never created a macro before and would really appreciate some help. I am trying to create a spreadsheet that will populate data based on a few criteria so that I do not have to constantly type everything out each and every time. On one tab, I want to have a start date and an end...
  3. M

    Minimization VBA Code

    <colgroup><col width="101" style="width:76pt"><col width="82" style="width:62pt"><col width="81" style="width:61pt"><col width="74" style="width:56pt"><col width="90" style="width:68pt"></colgroup><tbody> Good morning Mr Excel, would like to ask how to code the minimization VBA code. The...
  4. Greg Truby

    If Chip Pearson's website ever helped you, please jot a note...

    If you have ever done any serious VBA programming in Excel, then it's almost a lock that at some point you found yourself at an impasse, did a search and found yourself visiting www.cpearson.com where you found a well-documented and well-explained solution to the problem that had been vexing...
  5. J

    Return Row Heading, Column Heading and Cell with Value

    Hi, I have been trying a formula to return row and column heading from table 1 including the cell value of the cell with value in it. I had been trying to follow this post ...

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