Are all these sheets in 1workbook ?? What are in these 6 columns ?? Do you
want to summarize all 6 columns ??

Tell me alittle more maybe I could help you.

"JFO" wrote:

I have to prepare a worksheet that summarizes the latest data from about 6
columns in 180 detail worksheets. Any thoughts on how this can be done
efficiently?

JFO