| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using an "If" statement to move data from one column to another
Hi,
Tried looking this one up in the archives, and while I'm sure it's there I couldn't find it. I have data in column B, around 5000 rows. I'm wondering how to move any cells from column B to column G if and only if they contain certain words. Additionally, I'd like for the values copied into G to be put in rows 1, 2, 3, 4 etc. instead of the rows they're in now. An example here might help -- I have something like: Column B Hardwood Floors Carpeted Floors Laminate Floors Oak Wood Floors Tile Floors Beechwood Floors Supposing I wanted to pull out any cells with the word "wood" in them, I would want column G to look like this: Column G Hardwood Floors Oak Wood Floors Beechwood Floors in consecutive rows starting from the top. Essentially, the more automated this process is the better, since I have a new sheet with similar data every week for that week. Any help would be appreciated, thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I move a document from "recent items" to "documents" | New Users to Excel | |||
| Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
| CountA, Subtotal and "move to the first cell in the next column" | Excel Worksheet Functions | |||
| CountA, Subtotal and "move to the first cell in the next column" | Excel Discussion (Misc queries) | |||
| Change data in a single column from "last, first" to "first last" | Excel Discussion (Misc queries) | |||
Threaded Mode
