• 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. S

    Combo box with linked cell automatic update

    Hi, I have a list of projects on a sheet, every row in column D has a combo box which draws supplier name from the next sheet "SuppName". Dependent on the supplier name, there is a vlookup formula which brings in the spend by supplier in column E. Since the combo box is on every row (in reality...
  2. S

    Copying from worksheet and append to other worksheets based on criteria [Solved]

    I have a worksheet called “Rawdata”. I also have several worksheets named after account numbers eg 3101,3121,3131 etc. Every month I need to filter the ‘Rawdata’ using account number as criteria, and then APPEND to respective account sheet (as I don’t want to paste over previous months data)...
  3. S

    Sorting range using text contents as criteria

    Is there a way to sort a range of text data by specific criteria ie a word? Eg If A1:A100 contains various text data which may/may not contain the words 'tax', is it possible to sort the data in such a way that all words containing 'tax' appear at the top of the range??
Back
Top