How to create a long list from a lot of worksheets.

[imosri]

Hi all,

I need to "consolidate" a bunch of worksheets loaded with a unique webquery. The data colums are exactly the same of each worksheet.

Every time I open the file all the webqueries are executed and loaded on the pre-defined worksheets. The cell range name (except for the first three rows) are what I need to grab and move (actually, copy).

I need guidance to collect the results of every worksheet and put it on a blank worksheet.

Thanks in advance

Regards

 

[imosri]

Sorry, I didn't say thet I am using excel 2003

Regards

 

[Bong]

for each s in thisworkbook.sheets

?

_________________
Bob Rashkin

 

[SkipVought]

and you could use a series of ADO queries and stack the data in one sheet using the CopyFromRecordset method.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]