Excel Macro

  • Thread starter Thread starter Lita
  • Start date Start date
L

Lita

I need a macro that will take the infomation from one worksheet and replace
it with information from another worksheet if there are any changes in 3 rows
as long as all of the other information matches.

Lita
 
Hi,

Try recording the steps and then post your results. Very simply programming
is about details and you have given far too few.

If A1<>Sheets(2).Range("C5") then ' more conditions here.....
As stated Range("A1") = Sheets(2).Range("IV65123")
End If

Shane Devenshire
 

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 macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Copy Columns based on Header name 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Help with macro please 3
Macro to format multiple worksheets 24
Copy compare worksheets 1
Scatter plot / Data from matrices? 1

Back
Top