Re: $$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

It worked perfectly, a thousand thank you for your help :) 2010/11/29 ashish koul > try this > > Sub Macro1() > Dim z As Long > >Sheets("Folha1").Activate > If Sheets("Folha1").FilterMode Then > Sheets("Folha1").ShowAllData > End If > >Sheets("Folha1").Range("a65356").Select >

Re: $$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

try this Sub Macro1() Dim z As Long Sheets("Folha1").Activate If Sheets("Folha1").FilterMode Then Sheets("Folha1").ShowAllData End If Sheets("Folha1").Range("a65356").Select Selection.End(xlUp).Select z = ActiveCell.Row Sheets("Folha1").Range("$A$6:$J" & z).AutoFilter Fi

$$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

Hi guys i need badly your help, i want to copy the information of the range of cells from A7:G11 if the condition is true, in this case i want it to copy the information of the rows 8 and 10 to sheet number 2, thank you very much in advance, i put in anex an example of what i need. Jorge -- ---