Excel Question

  • Thread starter Thread starter Cathy
  • Start date Start date
C

Cathy

I want to past the total results of a filter command to a different column
but the same row. Now I can do it but only if the row are consec.
thank you and have a wonderful day and happy new year
 
Cathy
You will need VBA for that. This little macro will do that. As
written, it is assumed that your data is already filtered. I also assumed
your data is in Column A and you want the data copied to Column E. (the 5th
column). HTH Otto
Sub CopyFilter()
Dim rColA As Range
Dim i As Range
Set rColA = Range("A1", Range("A" & Rows.Count).End(xlUp))
For Each i In rColA.SpecialCells(xlCellTypeVisible)
i.Copy Cells(i.Row, 5)
Next i
End Sub
 
Back
Top