| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replace cell value
how to replace sheet1. cell a1 with shhet2 cell a1 if sheet 2 cell a2
matches sheet1 cell a2 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
replace cell value
Run this small macro:
Sub ReplaceIt() If Sheets("Sheet1").Range("A2").Value = Sheets("Sheet2").Range("A2").Value Then Sheets("Sheet1").Range("A1").Value = Sheets("Sheet2").Range("A1").Value End If End Sub -- Gary''s Student - gsnu200909 "hershel" wrote: how to replace sheet1. cell a1 with shhet2 cell a1 if sheet 2 cell a2 matches sheet1 cell a2 . |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
replace cell value
On Nov 22, 5:24*pm, Gary''s Student
wrote: Run this small macro: Sub ReplaceIt() If Sheets("Sheet1").Range("A2").Value = Sheets("Sheet2").Range("A2").Value Then * * Sheets("Sheet1").Range("A1").Value = Sheets("Sheet2").Range("A1").Value End If End Sub -- Gary''s Student - gsnu200909 "hershel" wrote: how to replace sheet1. cell a1 *with shhet2 cell a1 if sheet 2 cell a2 matches sheet1 cell a2 .- Hide quoted text - - Show quoted text - but I never made a macro ,how do i do it ? thanx |
| 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 one cell w/another cell unequal occurrences | Excel Discussion (Misc queries) | |||
| I can't see Highlight cell in Find & Replace Cell | Excel Discussion (Misc queries) | |||
| Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
| Excel - create button to replace cell content with cell value | Excel Worksheet Functions | |||
Linear Mode
