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

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top