| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find a Name, Duplicate a Row, Change a Value
Here's the problem:
Sheet is 20 columns by 1,000 rows. Column B contains 1,000 names. I want to search for a name. When found, I want to duplicate the row in which the name was found. Then I want to change one value in that row (in column D). I want to repeat this operation for many names. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find duplicate rows then deleting them | Excel Worksheet Functions | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
| find duplicate cells in Excel | Excel Discussion (Misc queries) | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
| how to change "Find" feature | Excel Worksheet Functions | |||
Threaded Mode
