paste the macro in worksheet change event . if your search criteria is in
sheet 1 the paste the macro in Worksheet_Change even tof sheet 1
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 3 And Target.Column = 5 Then
ActiveSheet.Rows("6:65356").Clear
Sheets("database").Activat
Thnaks Ashish.
It is very useful but i am not getting desired output when i copy VBA code
to my actual workbook.Please suggest Where i have to make change.
Regards,
C.G.Kumar
On Mon, Apr 18, 2011 at 6:18 PM, ashish koul wrote:
> try this see if it helps
>
> On Mon, Apr 18, 2011 at 2:21 PM,
try this see if it helps
On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar wrote:
> Hello,
> I have a very tricky problem. I have got an excel sheet having some columns
> but more than 5000 rows. In those columns there are some names which may/may
> not be similar to each other. I want to make a macro w
