Range Loop

Hi,

I have an excel spreadsheet that contains data in a number of columns (some contain data and some do not). I would like to have a seperate spreadsheet check the range (E3:IV3), if data is present in this row, I would like the seperate spreadsheet to write these cell values to corresponding rows in this sheet. How can I approach this issue?


example:

testScript.xls(Summary Tab)


A B C D E F G H I ........IV
App # 654 765 652



summary.xls(Findings Tab)

App #
654
765
652











Thanks in advance for anyhelp