Hi to all smart guys over here.
Straight to the point: I need a simple macro (excel 2010) that will copy all rows (range (A-I)) from active sheet that contains "a" in column "J" to another sheet last row. In addition I need content of cell C4 (active sheet) to be copied to column A for all copied rows in destination sheet.
Doable?
Bookmarks