Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub Macro1()
Dim iRow As Integer Dim ws As Worksheet Dim ws2 As Worksheet iRow = 2 Set ws = Sheets("Master") Set ws2 = Sheets("Compare") Do If ws.Cells(iRow, 1) < ws2.Cells(iRow, 1) _ Then ws2.Cells(iRow, 1).Insert Shift:=xlDown ws.Range("B" & iRow & ":D" & iRow).Copy _ ws2.Range("B" & iRow) iRow = iRow + 1 Loop Until ws.Cells(iRow, 1) = "" End Sub Hth, Merjet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
comparing | Excel Discussion (Misc queries) | |||
comparing | Excel Worksheet Functions | |||
Comparing more than two | Excel Worksheet Functions | |||
comparing worksheets | Excel Programming | |||
Comparing | Excel Programming |