select rows which has data

[venkatatcts]

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.

[DonkeyOte]

It's not entirely clear what you mean... I think you're saying you want to format A:I non-blanks in Main File post collation of data... you can (potentially) identify non-blanks using SpecialCells and Constants, eg:

Please Login or Register  to view this content.

the above formats Column A constants as being of General format and bold the values... obviously the range can be extended and/or embedded within a loop if each column is to have different formats applied.