Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to look up values in 2 different columns
Hi,
I need a macro which compares the values in colA and colC of sheet 1 to column D and column E of sheet 2, if both the value match, then it copies the contents from sheet2 col F,G and H into sheet1 colC,D and F. Please advise. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to look up values in 2 different columns
Sub CompareThis()
For iRow = 1 to 1000 If Sheets("Sheet1").cells(iRow, 1).Value = Sheets("Sheet2").cells (iRow, 4).Value And _ Sheets("Sheet1").cells(iRow, 3).Value = Sheets("Sheet2").cells(iRow, 5).Value Then Sheets("Sheet1").cells(iRow, 3).Value = Sheets("Sheet2").cells(iRow, 6).Value Sheets("Sheet1").cells(iRow, 4).Value = Sheets("Sheet2").cells(iRow, 7).Value Sheets("Sheet1").cells(iRow, 5).Value = Sheets("Sheet2").cells(iRow, 8).Value End IF Next iRow End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to look up values in 2 different columns
Thanks Hiran,
I'll try this out. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to look up values in 2 different columns
hello Hiran,
The code above gives an error saying: Subscript out of Range.Can you please advise. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to hide columns with zero values? | Excel Discussion (Misc queries) | |||
Macro to hide rows with zero values in columns | Excel Discussion (Misc queries) | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
Macro to copy columns values | Excel Programming | |||
How do I denote values stored in columns in my macro? | Excel Programming |