list combining

  1. P

    A More Complex List of Unique Distinct Values Based on a Criteria

    Hi! Here's my problem. Basically, I need the data that is on the table on the left to look the one on the right. Order IDs listed on B, the item/s ordered on C, and the status is on D. I need the pending orders listed on the table on the right so that: a) Only the pending orders are shown b)...
  2. R

    Drop Box Macro Trigger

    I have a workbook that has a running master list of job candidates. In the master list there are columns such as candidate, recruiter, location, and other general information. One of the columns contains status information such as "offer extended", "offer accepted", "reneged", "declined", etc...
  3. K

    Replicate one list against each value in another list - VBA?

    Hi All, This is my first post here so looking for a point in the right direction more than anything, I've done a lot of Google searching and forum searching but think the way I'm phrasing this question isn't coming up with the results i need. I want to replicate every cell in one column...
  4. I

    merging data

    hi guys and girls thank you for taking the time to read my post and i do hope someone can help me :) OK so here goes i have a workbook currently with two worksheets in them, each worksheet has a whole heap of data running from A1 right up to JS1436 the first few columns have things like...
  5. A

    Matching two lists with values that are similar, but not identical

    Hello all, I have a problem and I hope you can help. I'll try to explain it as clearly as possible. I have two columns with textual values in them. The values are similar, but not 1:1 identical. For instance, what is called in one column "I'm cell number 1" might be called in the other column...
  6. A

    Copy existing dynamic ranges into one list

    Hi everyone. Hoping for some help in copying a few dynamic ranges into another sheet as one list. For example, I have a sheet named ThemeValidationList which contains 5 dynamic ranges (named Theme1 to Theme5). I would like to know if there is a method that would copy each of these ranges and...
  7. K

    Create a List in MS Word from a Row of Excel Inputs

    Dear Potential Helper, I currently have a large database in the following format, where there are some cells that are empty: <tbody> Mr Patel Mr Smith Mrs Smith Mr Lewis Mrs Lewis Mrs Jones Ms Lewis </tbody> What I need to do is create a list of the outputs in the row, so for this row...
  8. B

    tracking groups called and data

    Hello, my name is Dan I work for a church that calls groups of persons for a food bank I want a simple one cell input i.e. type in group # or use drop-down then that number that is input is added to next blank cell either row or column i.e. I type "4" into cell a1 (or select from...
  9. B

    Very stupid question...

    I have a list. In column A1, there's a name. In column A2, there's a name. There are names all the way down to column A116. I would like instead of a column of names, just one cell with all of the names is column A to be separated by a comma. So, if my list was: Column A Mr. 1 Mr. 2 Mr. 3...

Some videos you may like

This Week's Hot Topics

Top