Hi Friends,

I am copying a data from three excel to one excel.

file1 file2 file3 to mainfile

after copying i have to format the mainfile.

Main file contains data only from A1:I1 only.

I have to select all the rows which has valid data.