Quote Originally Posted by Richard Buttrey View Post
Hi,

You haven't said whether all sheets in the workbook should be processed. More importantly your original post mentioned that the result should appear in one vertical row. This contradicts the example you attached.

Please clarify

One further Q. Is there only one cell on each sheet to be copied?

One has to ask the question why is the data captured in many sheets. What is the process that populates these sheets. Is it not possible to capture all data in one sheet from the start?

As you probable gather i am not savy with excel/stats etc I am going to ask a rudimentary Q
Please define "processed"

In terms of "vertical row" I meant to say horizontal row. The example is correct.
THere is only 1 cell in each sheet to be copied

In answer to "What is the process that populates these sheets. " Well this is a long story. I