Hi,
Some one Please help me to create VBA for the below.
I have large data in excel. I have to filter non blank cells of particulars column and need to paste in next work sheet.
INPUT DATA
Sample Image.JPG
In Below Example Column C to F is variable data.
Column A & B is fixed Data
I need to filter C coulmn with non blank cell, then i need to paste this in new worksheet along with fixed column of A&B. Like this need to do for remaining columns of D, E and F.
OUTPUT DATA
Sample Image Output.JPG
Some one please help. currently i am doing this manually taking more time
Bookmarks