Summarizing Several Empty/Non-Empty Columns into 1 Master List of another file

[gapollo]

Hello,

I've been wracking my brain on how to do this problem in VBA and I can't even figure out where to start.

See enclosed files. What I want to do is for the results in columns G through K of "Analysis" to be transferred to the appropriate columns of "Agenda", but only those columns that have any results below the title. For instance, the macro will look at column G of "Analysis" and see that there are no results below the title, go to the next column and so on until it comes to a column heading with results. Then it will take those results and copy them into "Agenda" - title and results - in C1; in this case, the first result with columns will be "Montréal". Then the macro will go back to "Analysis" and because the last column with results was I, will start at J. It will find the next column with results at K, take those results and put them - title and results - in "Agenda" in E1; in this case, "Roussillon". And so forth. Until it reaches the end of the columns (at the moment, at K, but there could be more).

The two files are open at the same time.

Any ideas how to do this?

Thanks!

[fredlo2010]

Can you attach a sample with the final Agenda? Thats where all your data will go correct ?

Thanks

[gapollo]

The attached "Agenda" file is the file into which the results are to be summarized.

[gapollo]

I thought that I would "repost" this thread since it seems that there are no takers... are there any?