My data
1 2 3 4 A
5 6 7 8 B
9 10 11 12 A
13 14 15 16 C
I want a macro that will copy the data if E coloumn have A If E coloumn have A then copy Complete row till next A in in E coloumn means From row1 row2 &row3And paste the data (copied rows)into sheet 2 in 1 row
Sheet2
A B C D E F G H I J K L M N O-Columns
1 2 3 4 A 5 6 7 8 A 9 10 11 12 A-Pasted data
I want the data to look like this i have lots of data so give me the code according to that