$$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: 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.

$$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 --~--~-~--~~~---~--~~ -