replace cell value

H

hershel

how to replace sheet1. cell a1 with shhet2 cell a1 if sheet 2 cell a2
matches sheet1 cell a2
 
G

Gary''s Student

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
 
H

hershel

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





- Show quoted text -
Click to expand...

but I never made a macro ,how do i do it ?

thanx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Word macro that can call cells out of Excel for a find and replace 0
Referencing cells in consecutive rows 2
VBA Coding Help for Beginner 0
VB code. If statement between two values 1
add hyperlink using sheet names and cells(i,j) 3
Need Help with a VBA subroutine 0
Vlookup and return sheet name also 2

Top