$$Excel-Macros$$ Re: Urgent help on simple macro

Hi Vinod Try the Macro below. Sub update() Dim x As Integer x = 3 Do While Sheet1.Cells(x, 2).Value If Sheet1.Cells(x, 4).Value = Core Then Sheet1.Cells(x, 2).Value = PAT End If x = x + 1 Loop End Sub -- --

$$Excel-Macros$$ Re: Filter problem

Hi Prashanth This could be the problem because on Worksheet Book Master (2) you are using a custom filter which is equals 3264. Try is greater than OR is greater than or equal to This should resolve the issue. :) Ewan --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: matching and finding data

Hi Lynn You have the answer in your question. You could use the function INDEX(array,row_number,[Column_num]), to get the row_number and column number you could use the function Match (lookup_value,lookup_array,match_type) where for match_type 0 = Exact Match, 1 = Less than, -1 = Greater than.