Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and replace in a different cell
If my data looks like this and I want to pick a number and have the cell
under it filled with a number of my choosing, what's my best option? A 10 20 30 40 50 B 25 35 45 55 65 C 15 20 25 30 35 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and replace in a different cell
Use VBA. Right click on sheet tab, view code, paste this in. Modify beginning
statements as desired. Sub FindReplace() 'Value you want to find xFind = 5 'Value you want to input xReplace = 50 Cells.Find(What:=xFind, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate ActiveCell.Offset(-1).Value = xReplace End Sub -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "PointerMan" wrote: If my data looks like this and I want to pick a number and have the cell under it filled with a number of my choosing, what's my best option? A 10 20 30 40 50 B 25 35 45 55 65 C 15 20 25 30 35 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
find replace the 1st character in a cell | Excel Discussion (Misc queries) | |||
Find/Replace changes cell format ?????? | Excel Discussion (Misc queries) | |||
Find and replace # with new line in a cell. | Excel Discussion (Misc queries) | |||
Find comment replace cell value | Excel Discussion (Misc queries) |