I have an excel worksheet that is currently filtered by a project #. I have certain columns that I would like to copy the information from one column to another. For example, copy column B to J and column A to I. I need for the headers to stay the same at the top which consists of the first two rows.
FIRST COPY THE FILTERED DATA IN ANOTHER SHEET OF THE FILE SO THAT IT CAN BE RETRIEVED IF THERE IS A MESS UP
try this macro and check whether it does what you want.
Dim r As Range, r1 As Range, r2 As Range
Dim j As Long, c As Range
Set r = ActiveSheet.UsedRange
Set r1 = Range(r.Cells(2, 1), r.End(xlDown).End(xlToRight))
Set r2 = r1.Columns("a:B").Cells.SpecialCells(xlCellTypeVisible)
For Each c In r2
If c.Rows.Hidden = False Then
c.Copy Cells(c.Row, c.Column + 8)
MsgBox "macro copying is over"
about other problems in your postings I shall look into them.