• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    Using COUNTIFS with the LEFT function

    Hello, I am trying to count the number of entries in 3 tables that have "M5" as the first two digits by combining a countifs with the left function but I cannot make it work. My attemps (which only use one table as they are tests) to far are as follows...
  2. G

    Hiding and Unhiding Rows with Filter Applied

    Hello All, I've got a bit of code that when you click on a button, it inserts a new row below with a unique ID number. There are a series of button down the list as they indicate a new section in the list and a button adds a new row to that section. The problem I have is that when I apply a...
  3. G

    How do I post my code in the forum in same format as is apprears on VBA

    Hello all, This is probably a very simple question but many times I have posted code and i loose all the formatting. How do I keep the VBA format when posting here? Regards, Gumbles
  4. G

    Camera Tool

    Hi there, I am using the camera tool to display a group of cells from one workbook to another. The tool works great when its in the same workbook as ive used it many times before. The problem im having is that when I have the camera tool referreing to another workbook it doesnt update. Even...
  5. G

    Adding Filter To One Column In Table

    Hello there, Im trying to apply a filter to only ONE column in my table. I know this is possible with normal columns by selecting the column before apply the filter but cant seem to apply this method on my table? Is this possible? Cheers, Gumbles
  6. G

    Shape to Insert Line and Add Unique ID Number

    Hi there, I am trying to create a peice of code that is generic for all shapes on a particular worksheet, so any shapes on the worksheet will use it when clicked. There is a list of headings and a shape is overlayed on each heading. WHen the user clicks on the shape it goes one row down from...
  7. G

    Perform Macro If Cell Changes

    Hello all, I have a small recorded macro that copies one list of cells (Week 1) to another list (Week 2) then deletes the first list. I would like to make this macro run automatically when the cell L2 changes. They are the current week and the next week so this needs to happen each week...
  8. G

    Button to know which cell its in

    Hello all, Im working with a friend to try and create a generic macro to assign to a button that, when clicked, will move down one cell (from where the button is clicked) and insert a row, simple enough. The problem we are having is that I dont know how to get the macro to know where it is...
  9. G

    Counting in a Dynamic List

    Hi there, I have looked throught Chandoo's website and found several functions (OFFSET or INDEX) that could apply to this but I can't seem to get it to work. I have a list in say B7:B9 and Im using COUNTA to count if anything is put in those cells. The problem is I want the COUNTA function...
  10. G

    Automatically Insert Row into Table

    Hello all, As I understand it when you format cells as a table,if you put data in the row below it will automatically add it to and format it as a table. Is it possible that aswell as formatting as a table it can insert a row into the worksheet? This is because I have data in the cells...
  11. G

    Scrollable Section for Data Input

    Hi there, apologies if this is the incorrect topic but I couldnt see any better matches. I am trying to create a section in excel (lets say A7:K10 with headings on the row above) that is scrollable (up to say 100 lines) and the information is entered directly into this scrollable section. The...
  12. G

    Multiple Conditions

    Hi there, I am struggling to find the best structure for a formula that must meet several conitions before taking the value from one worksheet and putting it in another. Due to IT security at work im unable to upload any samples so will do my best to explain my situation. I am taking the...
  13. G

    Warning Message to ensure Macros are enabled

    Hi there, I have a team project file that contains one small macro. My team is not all excel savvy so i would like to put a warning message that forces them to enable macros before they continue. I have tried to replicate the one chandoo has on his project portfolio but my VBA isnt as awesome...
  14. G

    COUNTIF with two criteria

    Hi there, I am trying to use the COUNTIF function to count issues only when the "issueopendate" range matches two criteria. 1. If it matches the number in cell "$O38" (e.g.32) 2. If the Text in the range "IssueQuestion" begins with a Q. (e.g. Q1.) The purpose is to first divide the isses...
  15. G

    Automatically cut a row to another worksheet based on cell value

    Hi there, I have a worksheet "Pending" that contains all of the current pending documents for the department. Column "C" is for completion date, and when I enter a date in here I would like the entire row to be cut and pasted into the worksheet "Approved". The row spans from "A:I". I have...
  16. G

    Return Last 5 Entries from an Issue List. [SOLVED]

    Hello everyone, I am an avid reader of this site but this is my first forum question so apologies if I make any mistakes. I am trying to return the 5 most recent closed issues from an issue list. I am using a helper column to identify the closed issues and their position in the table. I have...
Back
Top