list combining

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)...

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

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

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

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

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

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

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

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